Oninit Logo
The Down System Specialists
+1-913-732-8892
+44-2081-337529
Introduction Health Check Standby Admin Remote Admin Remote Monitoring Backup and Restore Custom Support Down Systems
Introduction BenchIt Toolkit Business Logic Extractor Forensic Tools Grafana Data Sources Nexus QueryLens Snooper
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 Firewall Protocols OpenSSH on Solaris
Unix & Web Services 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 -a All Info

The onstat -a command prints the equivalent execution of onstat -mcuskbtdlpCP plus the output of onstat -g all. The output from onstat -a is one of the items usually requested by Informix Technical Support when trying to decipher a potential problem. It should be noted that onstat -a does not actually capture all potential onstat options.

Notes

  • When trying to capture sufficient information for system analysis, perform onstat -aFR. This will capture flushing information in addition to the onstat options listed above. There are certain sections of the onstat -a command that dump memory maps. These sections tend to be quite long and in general offer no real useful information for analysis. When capturing onstat -a output, it is best to manually delete out these sections.
  • Because onstat commands are non-blocking and do not place latches or mutexes on shared memory, they may occasionally terminate with a "changing data structures" message. In most cases, simply rerunning the command will succeed.

    However, if the command is onstat -a, rerunning it may still produce the same error. In that case, run the individual onstat commands separately instead of using onstat -a.

    The onstat_all.sh script runs every onstat command individually, each under a labelled banner, as a drop-in alternative to onstat -a for capturing a full picture when onstat -a keeps erroring.

Monitoring and Tuning

  • To determine specific tuning for data given by the onstat -a command, refer to the desired command option in this guide for the area of interest.

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


You get all this for free.. think about what you get if you pay us