Log record subtype codes

The log record subtype code provides a more granular definition of the event that occurred and that generated the log record. Log record subtype codes are unique only within the scope of the corresponding log record type code.

Begin program-specific programming interface information.Log record type 0004 (SYSCOPY utility) has log subtype codes that correspond to the page set ID values of the table spaces that have their SYSCOPY records in the log (SYSIBM.SYSUTILX, SYSIBM.SYSCOPY, DSNDB01.DBD01, and DSNDB01.SYSDBDXA).

Log record type 0800 (quiesce) does not have subtype codes.

Some log record types (1000–8000 assigned by Db2) can have proprietary log record subtype codes assigned.

Subtypes for type 0002 (page set control)

Code
Type of event
0001
Page set open
0002
Data set open
0003
Page set close
0004
Data set close
0005
Page set control checkpoint
0006
Page set write
0007
Page set write I/O
0008
Page set reset write
0009
Page set status
000A
Compression dictionary write

Subtypes for type 0010 (system event)

Code
Type of event
0001
Begin checkpoint
0002
End checkpoint
0003
Begin current status rebuild
0004
Begin historic status rebuild
0005
Begin active unit of recovery backout
0006
Pacing record

Subtypes for type 0020 (unit of recovery control)

Code
Type of event
0001
Begin unit of recovery
0002
Begin commit phase 1 (Prepare)
0004
End commit phase 1 (Prepare)
0008
Begin commit phase 2
000C
Commit phase 1 to commit phase 2 transition
0010
End commit phase 2
0020
Begin abort
0040
End abort
0081
End undo
0084
End todo
0088
End redo

Subtypes for type 0100 (checkpoint)

Code
Type of event
0001
Unit of recovery entry
0002
Restart unit of recovery entry

Subtypes for type 2200 (savepoint)

Code
Type of event
0014
Roll back to savepoint
000E
Release to savepoint

Subtypes for type 4200 (end of rollback to savepoint)

Code
Type of event
0084
End of savepoint
0085
End of savepoint

Subtypes for type 4200 (diagnostic log record for TRUNCATE IMMEDIATE)

Code
Type of event
0085
Special begin for TRUNCATE IMMEDIATE
0086
Special commit for TRUNCATE IMMEDIATE

Subtypes for type 4400 (alter or modify log record)

Code
Type of event
0083
Alter or modify log record used for Db2 replication

End program-specific programming interface information.