onstat -s

Example Output

Figure 109. onstat -s Output

IBM Informix Dynamic Server Version 10.00.UC1 -- On-Line -- Up 03:57:17 -- 15360 Kbytes

Latches with lock or userthread set
name     address  lock wait userthread

Output Description

You can interpret output from this option as follows:

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 any user thread that is waiting for a latch

Instead this field contains the thread-control block address, which all threads have. You can compare this address with the user addresses in the onstat -u output to obtain the user-process identification number.

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.