onstat -s command: Print latch information

Use the onstat -s command to display general latch information, including the resource that the latch controls.

Read syntax diagramSkip visual syntax diagram
Syntax:

>>-onstat-- -s-------------------------------------------------><

Example output

Figure 1. onstat -s command output
IBM Informix Dynamic Server Version 14.10.F         -- On-Line (CKPT REQ) 
-- Up 00:19:21 -- 167608 Kbytes
Blocked:CKPT

Latches with lock or userthread set
name     address           lock wait userthread
physlog  4410d5a8          0    0    45a616b8

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 onstat -u (users) command 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
Is the shared-memory address of the user thread that is waiting for a latch, or is blank when no user threads are waiting
userthread
Is the shared-memory address of the user thread that holds the latch

This address corresponds to the value in the tcb column of the onstat -g ath output. You can compare this address with the user addresses in the onstat -u output to obtain the user-process identification number.


Copyright© 2019 HCL Technologies Limited