Data Movement Utilities Guide and Reference

Load Utility Log Records

The utility manager produces log records associated with a number of DB2 utilities, including the load utility. The log records mark the beginning or the end of a specific activity. The following log records are associated with load operations:

• Load Start. This log record is associated with the beginning of a load operation.
• Table Load Delete Start. This log record is associated with the beginning of the delete phase in a load operation. The delete phase is started only if there are duplicate primary key values. During the delete phase, each delete operation on a table record, or an index key, is logged.
• Load Delete Start Compensation. This log record is associated with the end of the delete phase in a load operation.
• Load Pending List. This log record is written when a load transaction commits. The pending list is a linked list of non-recoverable operations that are deferred until the transaction commits. No commit log record follows this transaction.
• A log record is written (during a non-recoverable load operation) every time a table space extent is allocated or deleted.

For a description of the structure of these log records, see the Administrative API Reference.