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 cfg Current Values of Configuration Parameters

The onstat -g cfg command displays information current values of configuration parameters

Option Description
onstat -g cfg Displays a list of configuration parameters and their current values.
onstat -g cfg config_parameter_name Displays only the current value of the specified configuration parameter.
onstat -g cfg full Displays all of the information about each configuration parameter, including the current value, the default value, the onconfig file value, and a description of the parameter.
onstat -g cfg full config_parameter_name Displays all of the information about the specified parameter.
onstat -g cfg diff Displays information about the configuration parameters with current values that are different from the permanent values that are in the onconfig file.
onstat -g cfg tunable Displays the default, original, and current values for all tunable parameters. An asterisk indicates that you can tune a configuration parameter dynamically.
onstat -g cfg msg Displays any messages, such as warnings or adjustments, that are associated with configuration parameters.

Output Description

Option Description
name Name of the configuration parameter
type Data type for the value
units Units in which the value is expressed
rsvd Indicates (with an asterisk) that the configuration parameter and its value are stored on the configuration reserved page If an asterisk is not present, the configuration parameter and its value are not stored on the configuration reserved page.
tunable Indicates (with an asterisk) that the configuration parameter can be tuned dynamically, for example, with an onmode -wm or -wf command If an asterisk is not present, the configuration parameter cannot be tuned dynamically.
min/max Minimum and maximum values for the configuration parameter
default Default value that is built into the server for the configuration parameter
onconfig Value of the configuration parameter, if any, that is in the onconfig.std file
current Current value of the configuration parameter A current value is different if it was modified dynamically, for example, with an onmode -wm command.
Description Description of the configuration parameter
message Message that identifies a changed configuration parameter value

Notes

    While onstat -c will show the values from the ONCONFIG file. But those values might not be the current values, i.e. ones change via an onmode -wm command. 

    [informix@theoden ~]$ onstat -c | egrep ^STATCHANGE
STATCHANGE 10

    [informix@theoden ~]$ onstat -g cfg STATCHANGE

IBM Informix Dynamic Server Version 14.10.FC5X3 -- On-Line -- Up 12 days 01:49:38 -- 12405464 Kbytes

name                      current value
STATCHANGE                13

    
[informix@theoden ~]$ onstat -g cfg diff

IBM Informix Dynamic Server Version 14.10.FC5X3-- On-Line -- Up 12 days 01:49:50 -- 12405464 Kbytes

id   name                      type   maxlen   units   rsvd  tunable
244  STATCHANGE                INT4   12       %             *

     onconfig: 10
     current : 13

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