Overview of DB2 log processing

If DB2 log records are available, Log Analyzer incorporates selected records in LUOWs to provide information about DB2 data and timings within IMS transactions. Log Analyzer includes the following transaction-related DB2 log records that comprise a unit of recovery (UR) in DB2:

  • Type 0020—unit-of-recovery control

    Type 0020 records have the following subtypes:

    • 0001—begin the unit of recovery
    • 0002—begin Commit Phase 1
    • 0004—end Commit Phase 1
    • 0008—begin Commit Phase 2
    • 000C—transition from Commit Phase 1 to Commit Phase 2
    • 0010—end Commit Phase 2
    • 0020—begin abort
    • 0040—end abort
    • 0081—end undo
    • 0084—end todo
    • 0088—end redo
  • Type 0200—unit-of-recovery undo
  • Type 0400—unit-of-recovery redo
  • Type 0600—unit-of-recovery combined undo/redo

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*