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
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 - Server Status Line

The commands and their outputs might not be available on your version, for example onstat -g rah is relatively new, or onstat -t no longer has a resident column

Want to see this on a PDA? All the commands are available in short form. For example, onstat -g seg can be seen www.oninit.com/onstatgseg. So just skip the spaces and dashes and it should just work. On Google Chrome just add www.oninit.com/ in front of the command you would normally run at the command line.

The onstat - command will produce a status line for the Informix server. The status line is produced with every onstat command that is executed with a few exceptions. The first portion identifies the server and the current version. The second portion indicates the status of the server. The status of the Informix server can take on one of the following 9 values: 

  • Initialization
  • Shutting Down
  • Quiescent
  • OnLine
  • Fast Recovery
  • Abort
  • Archive Backup
  • Unknown
  • Read-Only

Additionally, the server status can be accompanied by secondary information. The value of (Prim) or (Sec) will be displayed for systems running data replication. (CKPT REQ) will appear if a checkpoint is required; (CKPT INP) will appear if a checkpoint is in progress; and (LONGTX) will appear if a long transaction is currently being rolled back.

The final two portions provide the length of time the server has been up, followed by the total size of the shared memory segments (resident + virtual) used by the server in Kbytes. If the server is blocked from performing any work, the reason for the block is added to the end of the status line. The possible reasons for a blocked system include:

  • CKPT Checkpoint
  • LONGTX Long Transaction
  • ARCHIVE Archive Requested Block 
  • MEDIA_FAILURE             DBSpace being marked down
  • HANG_SYSTEM               Server Requested Block
  • DBS_DROP                  DBSpace is being dropped
  • DDR                       DDR Synchronization
  • LBU                       Prevent Log Backups
  • ARCHIVE_EBR               Blocked for External Backup and Recovery.
  • CHG_PLOG                  Blocked while physical log is being changed
  • CKPT INP                  Interval checkpoint in progress
  • DYNAMIC_LOG               Log file is being added dynamically
  • DYNAMIC_LOG_FOR_ER        Log file is being added dynamically in ER setup
  • FREE_LOG                  Log file is being freed
  • HA_CONV_STD               Blocked while High Availability server is being converted to standard server.
  • HA_FAILOVER               Blocked while High Availability server failover being processed.
  • HANG_SYSTEM               Database server failure
  • LAST_LOG_RESERVED4BACKUP  Waiting for last available log to be backed up
  • LOG_DROP                  Log file is being dropped
  • OVERRIDE_DOWN_SPACE       Waiting to override down dbspace setting because the ONDBSPACEDOWN onconfig parameter is set to WAIT

The following SQL should report the header information

select * from sysshmhdr where name like "ckpt%";

Notes

    If the system time is manually changed to the past and the server startup time is later than the current system time, the uptime is not available. In this situation, the header displays the text Uptime Unavailable.

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