Question & Answer
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… * 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.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21644973