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 thetbstat -u display, users section. These flags describe a process that is
waiting.The flags indicate which of the following events is causing the wait:
Transactionstatus 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
witha transaction.) This transaction state information is informative but not
required, unless you are administering OnLine in theX/Open environment.
If you are interested in transaction status information, which is especially
helpful if you are administeringIBM Informix STAR, refer to page 9-58.
If you are usingIBM Informix TP/XA, refer to the product documentation.
The user process state flags occupy the third position of each entry in the
tbstat-u display,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 topage 2-27 for a definition of a critical section.
BWaiting for a needed buffer to be released (refer to page2-53)
CWaiting for a checkpoint to complete (refer topage 2-72)
GWaiting for the physical or logical log buffer to flush (refer to
page 2-74)
LWaiting for a needed lock to be released (refer topage 2-38)
SWaiting for a needed latch to be released (refer topage 2-41)
TWaiting for a transaction (valid only in theX/Open environment)
XWaitingfor the rollback of a long transaction to complete (refer to
page 2-158)