Two-phase commit and logical-log records

The database server uses logical-log records to implement the two-phase commit protocol. You can use these logical-log records to detect heuristic decisions and, if necessary, to help you perform a manual recovery. (See Manually recovering from failed two-phase commit.)

The following logical-log records are involved in distributed transactions:
  • BEGPREP
  • PREPARE
  • TABLOCKS
  • HEURTX
  • ENDTRANS

For information about these logical-log records, see the chapter on interpreting the logical log in the HCL OneDB™ Administrator's Reference.

This section examines the sequence of logical-log records that are written during the following database server scenarios: