onstat -g ath command: Print information about all threads

Use the onstat -g ath command to display information about all threads.

Figure 1: Syntax:

1  onstat   -g ath

Example output

Figure 2: onstat -g ath command output
Threads:
 tid     tcb             rstcb        prty status             vp-class      name
 2       10bbf36a8        0            1    IO Idle              3lio        lio vp 0
 3       10bc12218        0            1    IO Idle              4pio        pio vp 0
 4       10bc31218        0            1    running              5aio        aio vp 0
 5       10bc50218        0            1    IO Idle              6msc        msc vp 0
 6       10bc7f218        0            1    running              7aio        aio vp 1
 7       10bc9e540        10b231028    1    sleeping secs: 1     1cpu        main_loop()
 8       10bc12548        0            1    running              1cpu        tlitcppoll
 9       10bc317f0        0            1    sleeping forever     1cpu        tlitcplst
 10      10bc50438        10b231780    1    IO Wait              1cpu        flush_sub(0)
 11      10bc7f740        0            1    IO Idle              8aio        aio vp 2
 12      10bc7fa00        0            1    IO Idle              9aio        aio vp 3
 13      10bd56218        0            1    IO Idle             10aio        aio vp 4
 14      10bd75218        0            1    IO Idle             11aio        aio vp 5
 15      10bd94548        10b231ed8    1    sleeping forever     1cpu        aslogflush
 16      10bc7fd00        10b232630    1    sleeping secs: 34    1cpu        btscanner 0
 32      10c738ad8        10b233c38    1    sleeping secs: 1     1cpu        onmode_mon
 50      10c0db710        10b232d88    1    IO Wait              1cpu        sqlexec

Output description

tid
Thread ID
tcb
Thread control block access
rstcb
RSAM thread control block access
prty
Thread priority
status
Thread status
vp-class
Virtual processor class
name
Thread name. For threads that are participating in parallel storage optimization operations, the name of the operation and the thread number.
  • compress.number = The thread is compressing data
  • repack.number = The thread is repacking data
  • uncompress.number = The thread is uncompressing data
  • update_ipa.number = The thread is removing outstanding in-place alter operations