Filter
Top Products
System Architecture 2-29
OnLine User Process Status and States
OnLine User Process Status and States
The tbstat -u command prints a profile of user process activity. To interpret
why a user process might be waiting for a latch or waiting for a checkpoint
to complete, refer to the information contained on the pages indicated.
OnLine user process status flags occupy the first flag position of each entry
in the tbstat -u display, users section. These flags describe a process that is
waiting. The flags indicate which of the following events is causing the wait:
Transaction status flags occupy the second position of each entry in the tbstat
-u display, users section. These flags describe the state of the transaction
associated with this user process. (Each OnLine user process is associated
with a transaction.) This transaction state information is informative but not
required, unless you are administering OnLine in the X/Open environment.
If you are interested in transaction status information, which is especially
helpful if you are administering IBM Informix STAR, refer to page 9-58.
If you are using IBM Informix TP/XA, refer to the product documentation.
The user process state flags occupy the third position of each entry in the
tbstat -udisplay,users section. These flags indicate if the OnLine user process
either is reading data (flag is R) or is inside a critical section of a transaction
(flag is X). Refer to page 2-27 for a definition of a critical section.
B
Waiting for a needed buffer to be released (refer to page 2-53)
C
Waiting for a checkpoint to complete (refer to page 2-72)
G
Waiting for the physical or logical log buffer to flush (refer to
page 2-74)
L
Waiting for a needed lock to be released (refer to page 2-38)
S
Waiting for a needed latch to be released (refer to page 2-41)
T
Waiting for a transaction (valid only in the X/Open environment)
X
Waiting for the rollback of a long transaction to complete (refer to
page 2-158)