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 wst Wait statistics

The onstat -g wst command displays wait statistics for threads within the system. 


name      tid    state          n     avg(us)     max(us)
sqlexec   32     yield bufwait  6     16166       46506
sqlexec   32     yield aiowait  34    33590       88997
sqlexec   32     yield time     2     156330      299586
sqlexec   32     yield forever  1     15999       15999
sqlexec   32     other cond     19    64.0s       1113.6s
sqlexec   32     other mutex    1     710         710
sqlexec   32     ready          64    1456        39583
sqlexec   32     run            63    52408       665865
scan_1.0  34     other cond     4     4240        8354
scan_1.0  34     other cond     1     715         715
scan_1.0  34     ready          6     283         492
scan_1.0  34     run            5     11205       33698

Output Description

Heading Description Format See Also
name The thread name. Str  
tid The thread ID. Dec  
state The state of the thread for this particular statistic. Str  
n The number of times the thread was in this state. Dec  
avg(us) The average user time in seconds spent in this state. Flt  
max(us) The maximum user time in seconds spent in this state. Flt  

Notes

  • Wait statistics can be enabled by adding 'WSTATS 1' to the configuration file.
  • The times are the max and average and cannot be summed to get total time for the session

Monitoring and Tuning

  • In earlier engines wait statistics should not be turned on for a production system. There will be a slight (5 - 10%) degradation in performance for the gathering of statistical information.

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