Utilities 7-99
Option Descriptions
-u OptionUse the-u option to print a profile of user activity. The output described in
this paragraph is provided for each user process.
Ata minimum, two user processes always appear in -u output: tbinit always
occupiesthe first entry and tbundo always occupies the second entry. If you
haveconfigured OnLine for additional page cleaners (specified as CLEANERS
inthe configuration file), each page-cleaner daemon, tbpgcl, is listed as well.
You can interpretoutput from this option as follows:
address is the shared-memory address of the user process (in the user
table). Compare this address with the addresses displayed in
the-s output (latches), the -b,-B, and -X output (buffers), and
the -k output (locks) to learn what resources this process is
holding or waiting for.
flags gives the status of the user process. The flag codes for
position 1 indicate if the process is waiting for a resource:
B
C
G
L
S
X
T
waiting for a buffer
waiting for a checkpoint
waiting for the log buffer
waiting for a lock
waiting for a latch
waiting for a long transaction rollback
waiting for a transaction (refer toChapter 9, “Product
Environment”)