IBM 000-8697 Manuale Utente

Product Environment

Three two-phase commit protocol errors require special attention from the
administrator:

■

-698 Inconsistent transaction ...

■

-699 Transaction heuristically rolled back

■

-716 Possible inconsistent transaction

If you receive either error -698 or -699, a heuristic rollback has occurred. If
you receive error -698, read the discussion pertaining to “Situation 2” on

 for an explanation of how the inconsistent transaction developed

and to learn the options available to you. If you receive error -699, read the
discussion pertaining to “Situation 1” on

If you decide to kill a coordinator database server process after the coordi-
nator has issued its final decision to “commit,” error -716 might be written to
the OnLine message log:

-716 Possible inconsistent transaction. Unknown servers are
<DBSERVERNAME> <DBSERVERNAME> ...

Your action creates the following problem: if a participating OnLine database
server does not receive the final decision from the coordinator (perhaps
because the participant is down), the participant begins to poll the coordi-
nator OnLine for instructions.

If the coordinator database server process has been terminated, the inquiring
participant OnLine receives a message stating that the transaction in question
is unknown. Under the presumed-abort optimization, the participant OnLine
interprets this lack of information as an instruction to roll back its piece of
work. If, in fact, the final decision was “commit,” your database system could
become inconsistent.