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

Rate this page:

(0 users)Average rating

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

Translate my page

Machine Translation

Content navigation