dbm_configget

With this command you display the value of one or several configuration parameters of 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. The values in the software version-specific configuration file override the values in the database computer-specific configuration file.

Note Note

Therefore, note that the parameter values displayed in 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 permission 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 Database Manager `INSTANCE`: Searches through the database-specific configuration file `INSTALLATION`: Searches through the software version-specific configuration file `GLOBAL`: Searches through the database computer-specific configuration file
`<parameter_name>`	Name of the configuration parameter of Database Manager If you do not specify this option, all the configuration parameters are 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 Database Manager CLI as the operator OLEG with the password MONDAY, connect to the database DEMODB, display the configuration parameter value of the status of the automatic log backup function (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 value 0 is displayed as the currently used value. The system has searched through all configuration files and then determined the value 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 receive the parameter value contained in that specific file, which might be different from the one displayed as per the example above. This means: If the parameter is also contained in the database-specific configuration file and has another value there, that value overrides the value displayed here:

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

OK

1

Result

The system displays that the parameter value contained in the software version-specific configuration file is 1.