Logical-log records written after a heuristic end transaction

The following figure illustrates the writing sequence of the logical-log records during a heuristic end transaction. The event is always the result of a database server administrator ending a transaction (see information about the onmode utility in the HCL Informix® Administrator's Reference) at a participant database server after the participant has sent a can commit message. In the following figure, the heuristic end transaction is assumed to have occurred at the Participant 1 (P1) database server. The result is an inconsistently implemented transaction. See The heuristic end-transaction scenario.
Figure 1. Logical-log records written during a heuristic end transaction
This figure shows how logical-log records are written during a heuristic end transaction. The paragraph that precedes this figure describes the content of the figure.

Copyright© 2020 HCL Technologies Limited