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 sts Max and current stack sizes

The onstat -g sts command displays the maximum and current stack sizes for each thread. Output is sorted by thread ID. 

Stack usage:                                                          
                                                                      
TID     Total   Max             Current         Thread Name           
                bytes   %       bytes   %                             
2       32768   1402    4       552     1       lio vp 0              
3       32768   973     2       552     1       pio vp 0              
4       32768   4462    13      552     1       aio vp 0              
5       131072  10419   7       552     0       msc vp 0              
6       32768   23748   72      2776    8       main_loop()           
7       32768   5715    17      664     2       sm_poll               
8       32768   4286    13      752     2       tlitcppoll            
9       32768   4443    13      960     2       tlitcppoll            
10      32768   10323   31      3280    10      sm_listen             
11      32768   2193    6       552     1       sm_discon             
12      32768   10323   31      4040    12      tlitcplst             
13      32768   10323   31      4040    12      tlitcplst             
14      32768   2880    8       600     1       flush_sub(0)          
15      32768   2263    6       600     1       flush_sub(1)

Output Description

Heading Description Format
TID The thread ID. Dec
Total The total number of bytes allocated for the stack. Dec
Max bytes The maximum number of bytes used from the stack. Dec
% The maximum percent of stack used. Dec
Current bytes The current number of bytes used from the stack. Dec
% The current percent of stack used. Dec
Thread Name The name of the thread associated with this stack. Str

Notes

    The default stack size is 32768 bytes (32K) and is controlled by the STACKSIZE configuration parameter.

Monitoring and Tuning

    If the max bytes column consistently shows a value larger than the default of 32K for the sqlexec threads, it might be advisable to increase the amount of memory allotted for the default stack size by changing the value of STACKSIZE in the configuration file to a larger value.

    Although it might appear that sessions are not fully utilizing the default amount of stack space assigned (32K), it is not recommended to set the default stack size to any value less than 32768 (32K).

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