The utility manager produces log records associated with the following DB2 common server utilities:
The log records signify the beginning or the end of the requested activity. All utility manager log records are marked as propagatable regardless of the tables that they affect.
This log record is associated with the beginning of catalog migration.
Table 116. Migration Begin Log Record Structure
| Description | Type | Offset (Bytes) |
|---|---|---|
| Log header | LogManagerLogRecordHeader | 0(20) |
| Migration start time | char[ ] | 20(10) |
| Migrate from release | unsigned short | 30(2) |
| Migrate to release | unsigned short | 32(2) |
| Total Length: 34 bytes | ||
This log record is associated with the successful completion of catalog
migration.
Table 117. Migration End Log Record Structure
| Description | Type | Offset (Bytes) |
|---|---|---|
| Log header | LogManagerLogRecordHeader | 0(20) |
| Migration end time | char[ ] | 20(10) |
| Migrate to release | unsigned short | 30(2) |
| Total Length: 32 bytes | ||
This log record is associated with the beginning of a load.
Table 118. Load Start Log Record Structure
| Description | Type | Offset (Bytes) |
|---|---|---|
| Log header | LogManagerLogRecordHeader | 0(20) |
| Log record identifier | unsigned long | 20(4) |
| Pool identifier | unsigned short | 24(2) |
| Object identifier | unsigned short | 26(2) |
| Flag | unsigned char | 28(1) |
| Object pool list | variable | 29(variable) |
| Total Length: 29 bytes plus variable | ||
This log record is written when a load transaction commits. The pending
list is a linked list of nonrecoverable operations which are deferred until
the transaction commits. No commit log record follows this transaction.
Table 119. Load Pending List Log Record Structure
| Description | Type | Offset (Bytes) | ||
|---|---|---|---|---|
| Log header | LogManagerLogRecordHeader | 0(20) | ||
| Time transaction committed | unsigned long | 20(4) | ||
| Authorization identifier of the applicationa | char[ ] | 24(9) | ||
| Pending list entries | variable | 33(variable) | ||
| Total Length: 33 bytes plus pending list entries propagatable (24 bytes plus pending list entries non-propagatable) | ||||
| ||||
This log record is associated with the end of a successful backup.
Table 120. Backup End Log Record Structure
| Description | Type | Offset (Bytes) |
|---|---|---|
| Log header | LogManagerLogRecordHeader | 0(20) |
| Backup end time | unsigned long | 20(4) |
| Total Length: 24 bytes | ||
This log record is associated with table space ROLLFORWARD recovery. It is
written for each table space that is successfully rolled forward.
Table 121. Table Space Rolled Forward Log Record Structure
| Description | Type | Offset (Bytes) |
|---|---|---|
| Log header | LogManagerLogRecordHeader | 0(20) |
| Table space identifier | unsigned short | 20(2) |
| Total Length: 22 bytes | ||
This log record is associated with table space ROLLFORWARD recovery. It
marks the beginning of a table space rollforward to a point in time.
Table 122. Table Space Roll Forward to PIT Begins Log Record Structure
| Description | Type | Offset (Bytes) |
|---|---|---|
| Time stamp to which table spaces are being rolled forward. | unsigned long | 0(4) |
| Time stamp for this log record. | unsigned long | 4(4) |
| Number of pools being rolled forward. | unsigned short | 8(2) |
| Integer list of pool IDs that are being rolled forward. | int*numpools | 10(variable) |
| Total Length: 10 bytes plus variable | ||
This log record is associated with table space ROLLFORWARD recovery. It
marks the end of a table space rollforward to a point in time.
Table 123. Table Space Roll Forward to PIT Ends Log Record Structure
| Description | Type | Offset (Bytes) |
|---|---|---|
| Time stamp for this log record. | unsigned long | 0(4) |
| Time stamp to which table spaces were rolled forward. | unsigned long | 4(4) |
| A flag whose value is TRUE if the roll forward was successful, or FALSE if the roll forward was canceled. | int | 8(4) |
| Total Length: 12 bytes | ||