Oninit Logo
The Down System Specialists
+1-913-674-0360
+44-2081-337529
Introduction Health Check Standby Admin Remote Admin Remote Monitoring Backup and Restore Custom Support Down Systems
Unix SQL Advanced SQL 4GL Applications Advanced 4GL IDS Admin Migrating to V14 IDS Performance Managing & Optimising SPL and Triggers IDS V14 Upgrading Very Old Versions Custom Training
Onstat Guide Error Code Guide Reference Datablades The Dumb DBA Sysmaster Fault Finder
Co-Location Web Hosting Managed Servers Web Development
BenchMark Tookkit RegExp Datablade
Partnerships Contact
Onstat
-g act -g afr -g all -g amx -g aqt -g arc -g ath -g btc -g buf -g cac -g cdr -g cluster -g cdr config -g cfg -g cmsm -g con -g cpu -g dbc -g ddr -g dic -g dis -g dll -g dmp -g dri -g dsc -g dsk -g dss
-g env -g ffr -g glo -g grp -g imc -g ioa -g iob -g iof -g iog -g ioq -g iov -g ipl -g lap -g laq -g lmm -g lmx -g lsc -g mem -g mgm -g nbm -g nif -g nsc -g nsd -g nss -g nta -g ntd -g ntm -g ntt -g ntu
-g opn -g osi -g pgp -g pos -g ppd -g ppf -g pqs -g prc -g proxy -g qst -g rah -g ras -g rbm -g rcv -g rep -g rea -g rss -g sch -g scn -g sds -g seg -g ses -g sle -g smb -g smx -g spi -g sql -g src -g ssc -g stk -g stm -g stq -g sts -g sym -g sync
-g rwm -g tgp -g tpf -g ufr -g wai -g vpcache -g wmx -g wst
-b/-B -F -g cac -g dic -g dsc -g prc -g ssc -g vpcache -h -p -X
-t/-T -g buf -g lap -g opn -g ppf -g scn
-g cat -g cdr -g cdrconfig -g ddr -g dss -g dtc -g grp -g nif -g que -g rcv -g rep -g rqm -g sync
-g cluster -g cmsm -g dri -g ipl -g laq -g proxy -g rss -g sds -g smx
-R -g afr -g ffr -g lmm -g lsc -g mem -g mgm -g nbm -g rbm -g seg -g ses -g stm -g stq -g ufr
-g imc -g nsc -g nsd -g nss -g nta -g ntd -g ntm -g ntt -g ntu
-G -u -x -g env -g his -g pqs -g ses -g sql
-g act -g ath -g cpu -g rea -g sle -g stk -g sts -g tpf -g wai -g wst
-a -b/-B -C -c -d/-D -F -f -G -h -i -j -k/-K -L -l -m -o -P -p -R -r -s -t/-T -u -X -x -z

onstat -g wai Waiting Threads

The onstat -g wai command displays a list of the threads, in the system, that are currently on the wait queue. The output is sorted by thread ID. 

Waiting 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() 
 10      14276800 0        3    sleeping forever        1cpu        sm_listen   
 11      1424ad58 0        2    sleeping secs: 1        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)
 16      142e42b8 140d4158 2    sleeping forever        1cpu        flush_sub(2)

Output Description

Heading Description Format See Also
tid The thread ID. Dec onstat -g ath
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 priority of the thread in the system. Dec  
status The current status of the thread (i.e. the reason it is on the wait queue). Str  
vp-class The virtual processor class upon which the thread runs. Str  
name The name of the thread. Str  

Notes

  • Threads on the wait queue are either waiting on condition such as a mutex, condition or join, or they are sleeping, either for a specific number of seconds or forever.

Monitoring and Tuning

  • Threads will wait for a variety of reasons. For sqlexec threads, the most common reasons are SM_READ and NETNORM, which indicate the server is waiting for a request from the front end program.

To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.