IBM 000-8697 User Manual

IBM Informix OnLine Database Server Administrator’s Guide

The

isolation

 field describes the transaction isolation level. Four isolation

levels are valid under

IBM I

nformix

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

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).

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.