dbm_configget

You display the value of one or several configuration parameters of the Database Manager. You can use options to limit the display.

The values of the configuration parameters are stored in three different configuration files:

a database-specific configuration file
a software version-specific configuration file
a database computer-specific configuration file

The parameter values in the database-specific configuration file override the values in the software version-specific configuration file. These, in turn, override the values of the database computer-specific configuration file.

Note Note

Therefore, note that the values shown for the configuration parameter in the Database Manager can be overridden by other values so that they do not represent the current values being used.

End of the note.

Prerequisites

You have the server authorization InstallMgm.

Structure

dbm_configget [<file_range>] [<parameter_name>]<file_range>:: = ALL|INSTANCE|INSTALLATION|GLOBAL

Options
Option	Description
`<file_range>`	Configuratrion file(s) to be searched through Possible values are: `ALL \| INSTANCE \| INSTALLATION \| GLOBAL` `ALL`: Default value - searches through all three configuration files of the Database Manager `INSTANCE`: Searches through the database-specific configuration file `INSTALLATION`: Searches the software version-specific configuration file `GLOBAL`: Searches the database computer-specific configuration file
`<parameter_name>`	Name of the configuration parameter of the Database Manager If you do not specify this option, all the configuration parameters will be displayed

Result

OK

<parameter_value>

<parameter_name> = <parameter_value>

...

Values for the Reply Fields
Value	Description
`<parameter_value>`	Value of the configuration parameter
`<parameter_name>`	Name of the configuration parameter

In the event of errors, see Reply Format.

Example

Displaying the parameter value without specifying a configuration file

Call the Database Manager CLI as the operator OLEG with the password MONDAY, connect to the database instance DEMODB, display the configuration parameter value of the status of the automatic log backup (the status of the automatic log backup can only have the value 0 or 1):

>dbmcli -u OLEG,MONDAY -d DEMODB dbm_configget AUTOSAVE

OK

0

Result

The system searches in all configuration files. They contain the currently used value that was determined according to the above rule.

Displaying the parameter value specifying a configuration file

If you additionally specify that only the software version-specific configuration file is to be searched, you may receive a different value for the same parameter. This is the value that contained in that file. This means: If this parameter is also contained in the database-specific configuration file and then receives another value there, it overrides value displayed here:

>dbmcli -u OLEG,MONDAY -d DEMODB dbm_configget INSTALLATION AUTOSAVE

OK

1

Result

The system only searches the software version-specific configuration file. The parameter is stored there with the value 1.