IBM 000-8697 Manual Do Utilizador

System Architecture

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 I

nformix

STAR

, refer to

If you are using

IBM I

nformix

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 to

B

Waiting for a needed buffer to be released (refer to page

2-53

)

C

Waiting for a checkpoint to complete (refer to

)

G

Waiting for the physical or logical log buffer to flush (refer to

)

L

Waiting for a needed lock to be released (refer to

)

S

Waiting for a needed latch to be released (refer to

)

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

)