IBM 000-8697 Transaction isolation Field, Transaction retries Field, Transaction coordinator Field

9-62 IBM Informix OnLine Database Server Administrator’s Guide
Track a Transaction with tbstat Output
Transaction isolation Field
Theisolation field describes the transaction isolation level. Four isolation
levels are valid underIBM 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 atransaction
■Databases that do not use logging
For more details about isolation levels, refer toIBM Informix Guide to SQL:
Tutorial.
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
thistransaction. The name that appears is the DBSERVERNAME of the coordi-
nator OnLine.