Filter
Top Products
9-62 IBM Informix OnLine Database Server Administrator’s Guide
Track a Transaction with tbstat Output
Transaction isolation Field
The isolation field describes the transaction isolation level. Four isolation
levels are valid under IBM Informix STAR:
■ COMMIT (Committed Read)
■ CURSOR (Cursor Stability)
■ DIRTY (Dirty Read)
■ REPEAT (Repeatable Read)
A fifth value, NO TRANS, might appear in this field. NO TRANS is reserved
for two situations:
■ Database user processes (such as daemons) that perform work but
are not considered to be owners of a transaction
■ Databases that do not use logging
For more details about isolation levels, refer to IBM Informix Guide to SQL:
T
utorial.
Transaction retries Field
The transaction retries field indicates the number of times that the period
specified by the TXTIMEOUT configuration parameter has expired (and this
participant transaction has attempted to contact its coordinator).
Transaction coordinator Field
The transaction coordinator field specifies the name of the coordinator of
this transaction. The name that appears is the DBSERVERNAME of the coordi-
nator OnLine.