IBM 000-8697 User Manual

Utilities

Use the -s option to display general latch information. (Refer to

for

more details about latches.) You can interpret output from this option as
follows:

name

identifies the resource the latch controls:

archive
bf
bh
chunks
ckpt
dbspace
flushctl
flushr
locks
loglog

LRU

physb1
physb2
physlog
pt
tblsps
users

archiving
buffers
hash buffers
chunk table
checkpoints
dbspace table
page flusher control
page cleaners
lock table
logical log

LRU

 queues

first physical log buffer
second physical log buffer
physical log
tblspace tblspace
tblspace table
user table

address

is the address of the latch. This address appears in the -u
(users) output

wait

 field if a process is waiting for the latch.

lock

indicates if the latch is locked and set. The codes that indicate
the lock status (1 or 0) are machine-dependent.

wait

indicates if any user process is waiting for the latch.

user

is the shared-memory address of the owner of the latch. This
address identifies the user process in the -u (users) output.