dbm_configget

Use

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.

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.

Prerequisites

You have the server authorization InstallMgm.

Syntax

dbm_configget [<file_range>] [<parameter_name>]

<file_range>:: = ALL|INSTANCE|INSTALLATION|GLOBAL

Options

Option

Description

<file_range>

Configuration file(s) to be scanned. Possible values are:

ALL|INSTANCE|INSTALLATION|GLOBAL

ALL: Default value
Searches 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

Reply

OK

<parameter_value>

or

<parameter_name> = <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.

Examples

Displaying the parameter value without specifying a configuration file

Call the Database Manager CLI, log on as operator OLEG with password MONDAY, connect to the database instance DEMODB, display the configuration parameter value of the automatic log backup function (this function 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. The currently used value that was determined according to the above rule (section: “Use”) is displayed:

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.

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.