Log record type codes
The type code of a log record tells what kind of Db2 event the record describes.
- Code
- Type of event
- 0002
- Page set control
- 0004
- SYSCOPY utility
- 0010
- System event
- 0020
- Unit of recovery control
- 0100
- Checkpoint
- 0200
- Unit of recovery undo
- 0400
- Unit of recovery redo
- 0800
- Archive log command
- 1000 to 8000
- Assigned by Db2
- 2200
- Savepoint
- 4200
- End of rollback to savepoint
- 4400
- Alter or modify recovery log record
A single record can contain multiple type codes that are combined. For example, 0600 is a combined UNDO/REDO record; F400 is a combination of four Db2-assigned types plus a REDO. A diagnostic log record for the TRUNCATE IMMEDIATE statement is type code 4200, which is a combination of a diagnostic log record (4000) and an UNDO record (0200).