The onstat -g ath command displays a list of all threads in the system. The output is sorted by thread ID.
Threads: tid tcb rstcb prty status vp-class name 2 141c9270 0 2 sleeping forever 4lio lio vp 0 3 141e3138 0 2 sleeping forever 5pio pio vp 0 4 141f8138 0 2 sleeping forever 6aio aio vp 0 5 1420d138 0 2 sleeping forever 7msc msc vp 0 6 1423a228 140d3018 4 sleeping secs: 1 1cpu main_loop() 7 1424abe8 0 2 running 1cpu sm_poll 8 14256e00 0 2 running 8tli tlitcppoll 9 14266800 0 2 running 9tli tlitcppoll 10 14276800 0 3 sleeping forever 1cpu sm_listen 11 1424ad58 0 2 sleeping secs: 2 1cpu sm_discon 12 142a1930 0 3 sleeping forever 1cpu tlitcplst 13 142adba8 0 3 sleeping forever 1cpu tlitcplst 14 142c2c20 140d35d8 2 sleeping forever 1cpu flush_sub(0) 15 142d92b8 140d3b98 2 sleeping forever 1cpu flush_sub(1) ..... 141 148b99a8 0 4 sleeping forever 1cpu kaio 142 142fabb8 14a58018 3 sleeping forever 1cpu aslogflush 143 14aa0380 14a585d8 2 sleeping secs: 44 1cpu btclean 151 14c91d28 14a59158 4 sleeping secs: 1 1cpu onmode_mon 213 14c91ec0 14a58b98 2 cond wait sm_read 1cpu sqlexec 349 14abae60 14a59718 2 cond wait netnorm 1cpu sqlexec 357 1476f478 14a59cd8 2 cond wait netnorm 1cpu sqlexec 358 1477b4c0 14a5a298 2 cond wait netnorm 1cpu sqlexec 359 1477ba98 14a5a858 2 cond wait netnorm 1cpu sqlexec
Heading | Description | Format | See Also |
---|---|---|---|
tid | The thread id incrementally assigned by OnLine. | Dec | onstat -g tpf |
tcb | The in-memory address of the thread control block. | Hex | |
rstcb | The in-memory address of the RSAM thread control block. | Hex | |
prty | The internal priority of the thread. | Dec | |
status | The current status of the thread. Important thread states
ready ready to run waiting on a VP to pick and run thread running the one thread, on a given VP, that’s currently executing sleeping yielded its VP, so others can run secs: #seconds wants to retry/recheck/rerun after #seconds secs: 0 wants to continue running, but giving others a chance too forever sleep until woken / needed again yield buffwait wants to access a bufferpool page owned by different thread yield lockwait wants to lock a data resource currently locked by different session IO Wait waiting on IO (usually disk) to complete fork waiting on a child process to return cond wait cond_name woken when spec. condition met mutex wait mutex_name trying to acquire mutex woken when released by curr . holder join wait joinee_id waiting on completion of task carried out by joinee specialized thread |
Str | onstat -g con |
vp-class | The VP class and number on which the thread is running. The VP classes include the following:
CPU CPU VP AIO Asynchronous I/O LIO Logical Log I/O PIO Physical Log I/O MSC Miscellaneous ADM Administrative ADT Auditing OPT Optical SOC Socket TLI TLI SHM Shared Memory USR User Define Routine VP |
Str | onstat -g glo |
name | The name of the thread. | Str |
To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.