IBM Support

How do DB2 utilities affect transaction logging?

Technote (FAQ)


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

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:

Using the RUNSTATS utility generates no transaction log activity.

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

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.

The EXPORT utility generates no transaction log activity.


Document information

More support for: DB2 for Linux, UNIX and Windows
OTHER - Uncategorised

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: 18 November 2015