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.

Figure 1: Syntax:

This onstat -g cfg command has the following formats:

onstat -g cfg command options
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