IBM 000-8697 Transaction ag Field

9-60 IBM Informix OnLine Database Server Administrator’s Guide
Track a Transaction with tbstat Output
Transaction flag Field
The transaction flag field describes the state of the transaction. Flags can
appear in the first, middle, and last position of the field as described in the
following table.
Position Flag Description
1 A Attached. This flag appears in the first position when a trans-
actionis owned by (attached to) a database server process. If this
flag does not appear, the transaction is orphaned
1 C Clean. This flag indicates that this transaction terminated
prematurely(probably because of a crash) and requires cleanup.
3 B Begin. Work has been logged for this transaction. This flag
appears when a writable operation is encountered within the
transaction. (A BEGIN WORK statement does not set this flag.)
3 C Commit. The transaction is being committed. If a failure occurs
while this flag is set, the OnLine recovery mechanism rolls
forward this transaction as if it were committed.
3 H Heuristic.The transaction is being heuristically rolled back. If a
failureoccurs while this flag is on, the recovery mechanism rolls
back this transaction as if it were aborted.
3 P Prepare. This transaction has been prepared to commit. Once a
transaction has reached this state, any decision to complete the
transaction independently of instructions from the coordinator
is considered a heuristic decision. If a failure occurs while this
flag is set, automatic recovery ensures that the transaction
completes correctly.
3 R Rollback. This transaction is being rolled back. If a failureoccurs
whilethis flag is on, this transaction will be rolled back as part of
automatic recovery.
(1 of 2)