IBM Support

How do DB2 utilities affect transaction logging?

Technote (FAQ)


Question

How some of the more commonly used utilities affect transaction logging follows:

* REORG
Specification of the ONLINE or INPLACE parameters requires more transaction log space than that of OFFLINE, though OFFLINEneeds to take a ‘shadow’ copy of the object for the duration of operation. Reference the following information:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.perf.doc/doc/c0024860.html

* RUNSTATS
Using the RUNSTATS utility generates no transaction log activity.

* LOAD
The LOAD utility generates a minimal level of transaction log activity.

* IMPORT
The import utility logs each row imported and can be intensive when importing a large volume of data. The LOAD utility is recommended over the IMPORT utility when loading data.

* EXPORT
The EXPORT utility generates no transaction log activity.

Answer

Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.5, 9.7, 9.8, 10.1, 10.5

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Reference #: 1644973

Modified date: 2014-05-23