onstat -g ath command: Print information about all threads
Use the onstat -g ath command to display information about all threads.
Example 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 sqlexecOutput 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