Administrative API Reference

Appendix F. DB2 Common Server Log Records

This section describes the structure of the DB2 common server log records returned by sqlurlog - Asynchronous Read Log.

All DB2 common server log records begin with a log manager header. This header includes the total log record size, the log record type, and transaction-specific information. It does not include information about accounting, statistics, traces, or performance evaluation. For more information, see Log Manager Header.

Log records are uniquely identified by a log sequence number (LSN). The LSN represents a relative byte address, within the database log, for the first byte of the log record. It marks the offset of the log record from the beginning of the database log.

The log records written by a single transaction are uniquely identifiable by a field in the log record header. The unique transaction identifier is a six-byte field that increments by one whenever a new transaction is started. All log records written by a single transaction contain the same identifier.

When a transaction performs writable work against a table with DATA CAPTURE CHANGES on, or invokes a log writing utility, the transaction is marked as propagatable. Only propagatable transactions have their transaction manager log records marked as propagatable.

Table 94. DB2 Common Server Log Records

Data Manager
Initialize Table New permanent table creation.
Import Replace (Truncate) Import replace activity.
Rollback Insert Rollback row insert.
Reorg Table REORG committed.
Create Index, Drop Index Index activity.
Create Table, Drop Table, Rollback Create Table, Rollback Drop Table Table activity.
Alter Table Attribute Propagation, check pending, and append mode activity.
Alter Table Add Columns, Rollback Add Columns Adding columns to existing tables.
Insert Record, Delete Record, Rollback Delete Record, Rollback Update Record Table record activity.
Update Record Row updates where storage location not changed.
Long Field Manager
Add/Delete/Non-update Long Field Record Long field record activity.
LOB Manager
Insert LOB Data Log Record (AFIM_DATA) Adding LOB data with logging.
Insert LOB Data Log Record (AFIM_AMOUNT) Adding LOB data without logging.
Transaction Manager
Normal Commit Transaction commits.
Heuristic Commit Indoubt transaction commits.
MPP Coordinator Commit Transaction commits. This is written on a coordinator node for an application that performs updates on at least one subordinator node.
MPP Subordinator Commit Transaction commits. This is written on a subordinator node.
Normal Abort Transaction aborts.
Heuristic Abort Indoubt transaction aborts.
Local Pending List Transaction commits with a pending list existing.
Global Pending List Transaction commits (two-phase) with a pending list existing.
XA Prepare XA transaction preparation in two-phase commit environments.
MPP Subordinator Prepare MPP transaction preparation in two-phase commit environments. This log record only exists on subordinator nodes.
Backout Free Marks the end of a backout free interval. The backout free interval is a set of log records that is not to be compensated if the transaction aborts.
Utility Manager
Migration Begin Catalog migration starts.
Migration End Catalog migration completes.
Load Start Table load starts.
Table Load Delete Start Load delete phase starts.
Load Delete Start Compensation Load delete phase ends.
Load Pending List Table load completes.
Backup End Backup activity completes.
Tablespace Rolled Forward Table space rollforward completes.
Tablespace Roll Forward to PIT Begins Marks the beginning of a table space rollforward to a point in time.
Tablespace Roll Forward to PIT Ends Marks the end of a table space rollforward to a point in time.
Datalink Manager
Link File Written when an insert or an update on a table with a DATALINK column creates a link to a file.
Unlink File Written when a delete or an update on a table with a DATALINK column drops a link to a file.
Delete Group Written when a table with DATALINK columns (having the file link control attribute) is dropped.
Delete PGroup Written when a table space is dropped.
DLFM Prepare Written during the prepare phase, when a two-phase commit is used for transactions involving DB2 Data Links Managers.

[ Top of Page | Previous Page | Next Page ]

Data Manager
Initialize Table	New permanent table creation.
Import Replace (Truncate)	Import replace activity.
Rollback Insert	Rollback row insert.
Reorg Table	REORG committed.
Create Index, Drop Index	Index activity.
Create Table, Drop Table, Rollback Create Table, Rollback Drop Table	Table activity.
Alter Table Attribute	Propagation, check pending, and append mode activity.
Alter Table Add Columns, Rollback Add Columns	Adding columns to existing tables.
Insert Record, Delete Record, Rollback Delete Record, Rollback Update Record	Table record activity.
Update Record	Row updates where storage location not changed.
Long Field Manager
Add/Delete/Non-update Long Field Record	Long field record activity.
LOB Manager
Insert LOB Data Log Record (AFIM_DATA)	Adding LOB data with logging.
Insert LOB Data Log Record (AFIM_AMOUNT)	Adding LOB data without logging.
Transaction Manager
Normal Commit	Transaction commits.
Heuristic Commit	Indoubt transaction commits.
MPP Coordinator Commit	Transaction commits. This is written on a coordinator node for an application that performs updates on at least one subordinator node.
MPP Subordinator Commit	Transaction commits. This is written on a subordinator node.
Normal Abort	Transaction aborts.
Heuristic Abort	Indoubt transaction aborts.
Local Pending List	Transaction commits with a pending list existing.
Global Pending List	Transaction commits (two-phase) with a pending list existing.
XA Prepare	XA transaction preparation in two-phase commit environments.
MPP Subordinator Prepare	MPP transaction preparation in two-phase commit environments. This log record only exists on subordinator nodes.
Backout Free	Marks the end of a backout free interval. The backout free interval is a set of log records that is not to be compensated if the transaction aborts.
Utility Manager
Migration Begin	Catalog migration starts.
Migration End	Catalog migration completes.
Load Start	Table load starts.
Table Load Delete Start	Load delete phase starts.
Load Delete Start Compensation	Load delete phase ends.
Load Pending List	Table load completes.
Backup End	Backup activity completes.
Tablespace Rolled Forward	Table space rollforward completes.
Tablespace Roll Forward to PIT Begins	Marks the beginning of a table space rollforward to a point in time.
Tablespace Roll Forward to PIT Ends	Marks the end of a table space rollforward to a point in time.
Datalink Manager
Link File	Written when an insert or an update on a table with a DATALINK column creates a link to a file.
Unlink File	Written when a delete or an update on a table with a DATALINK column drops a link to a file.
Delete Group	Written when a table with DATALINK columns (having the file link control attribute) is dropped.
Delete PGroup	Written when a table space is dropped.
DLFM Prepare	Written during the prepare phase, when a two-phase commit is used for transactions involving DB2 Data Links Managers.