IBM 000-8697 User Manual

IBM Informix OnLine Database Server Administrator’s Guide

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.

1

A

Attached. This flag appears in the first position when a trans-
action is 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
failure occurs 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 failure occurs
while this flag is on, this transaction will be rolled back as part of
automatic recovery.

 (1 of 2)