Situation 1: Coordinator issues a commit and all participants report heuristic rollbacks

The coordinator gathers all responses from participants. If every participant reports a heuristic rollback, the following events occur as a consequence:
  1. The coordinator writes the following message to its own database-server message log:
    Transaction heuristically rolled back.
  2. The coordinator sends a message to all participants to end the transaction.
  3. Each participant writes an ENDTRANS record in its logical-log buffer. (The transaction entry is removed from the transaction table.)
  4. The coordinator returns error -699 to the application, as follows:
    -699 Transaction heuristically rolled back.
  5. In this situation, all databases remain consistent.

Copyright© 2019 HCL Technologies Limited