onstat -s command: Print latch information
Use the onstat -s command to display general latch information, including the resource that the latch controls.
Example output
OneDB Version 1.0.1.0 -- 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 45a616b8Output 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 (
1or0) 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.