Output Description

name

identifies the resource that the latch controls with the following abbreviations:

archive

Storage-space backup

bf

Buffers

bh

Hash buffers

chunks

Chunk table

ckpt

Checkpoints

dbspace

Dbspace table

flushctl

Page-flusher control

flushr

Page cleaners

locks

Lock table

loglog

Logical log

LRU

LRU queues

physb1

First physical-log buffer

physb2

Second physical-log buffer

physlog

Physical log

pt

Tblspace tblspace

tblsps

Tblspace table

users

User table

address

is the address of the latch. This address appears in the -u (users) output wait field if a thread 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 computer dependent.

wait

indicates if any user thread is waiting for the latch.

userthread

is the shared-memory address of the owner of the latch. In contrast to the user fields of other onstat options, this field does not contain the rstcb address because not all threads that own latches are user threads. Instead this field contains the thread-control block address, which all threads have. To obtain the rstcb address from the tcb address, examine the output of the onstat -g ath option, which lists both addresses for each user thread.