IBM Support

How do DB2 utilities affect transaction logging?

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.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Recovery - Logging","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.8;9.7;9.5;10.1;10.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21644973

Page Feedback