
Utilities 7-99
Option Descriptions
-u Option
Use the -u option to print a profile of user activity. The output described in
this paragraph is provided for each user process.
Ataminimum,twouser processesalwaysappearin-u output:tbinit always
occupies the first entry andtbundo always occupies the second entry. If you
haveconfiguredOnLineforadditionalpagecleaners(specifiedas
CLEANERS
in the configuration file), each page-cleaner daemon, tbpgcl, is listed as well.
You can interpret output 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 to Chapter 9, “Product
Environment”)
Komentarze do niniejszej Instrukcji