onstat -g cfg command: Print the current values of configuration parameters

Use the onstat -g cfg command to print a list of configuration parameters with their current values. You can use more command options to print more information about the configuration parameters.

Read syntax diagramSkip visual syntax diagram
Syntax:

>>-onstat-- -g--cfg--+---------+--+-----------------------+----><
                     +-full----+  '-config_parameter_name-'   
                     +-diff----+                              
                     +-tunable-+                              
                     '-msg-----'                              

This onstat -g cfg command has the following formats:

Command 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.

Example output

The following portion of sample output of the onstat -g cfg command shows that the value of the DEADLOCK_TIMEOUT configuration parameter was dynamically changed to 90 seconds after the database server started:

id   name                  type   units   rsvd  tunable
26   DEADLOCK_TIMEOUT      INT4   Seconds       *      

     min/max : 0,2147483647
     default : 60
     onconfig:
     current : 90

     Description:
     Use the DEADLOCK_TIMEOUT configuration parameter to specify the
     maximum number of seconds that a database server thread can wait
     to acquire a lock.
ROOTNAME                  rootdbs

The following portion of sample output of the onstat -g cfg diff command shows the default, current, and onconfig file values of the TBLTBLFIRST and TBLTBLNEXT configuration parameters:

id   name                      type   units   rsvd  tunable
53   TBLTBLFIRST               INT4   KB            *

     default : 500
     onconfig: 0
     current : 250


id   name                      type   units   rsvd  tunable
54   TBLTBLNEXT                INT4   KB            *

     default : 100
     onconfig: 0
     current : 150

The following portion of sample output shows information for the MSGPATH configuration parameter. Here, there is no default value that is built into the configuration parameter and the onconfig file and current values are the same.

id   name                      type   units   rsvd  tunable
10   MSGPATH                   CHAR           *     *

     default : 
     onconfig: /work2/JC/online.log
     current : /work2/JC/online.log

The following portion of sample output of the onstat -g cfg msg command shows messages that identify configuration parameters with changed values:

Configuration Parameters With Messages

name             message
TBLTBLFIRST      Parameter's user-configured value was adjusted.
TBLTBLNEXT       Parameter's user-configured value was adjusted.
BUFFERPOOL       Parameter's user-configured value was adjusted.
STACKSIZE        Parameter's user-configured value was adjusted.
VPCLASS          Parameter's user-configured value was adjusted.

Output 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

Copyright© 2019 HCL Technologies Limited