param_extgetall

Use

You display the data for all database parameters from the database parameter file and the default parameter file.

The display contains the name of each database parameter, its data type, and its current value. This is the value that is copied from the parameter file at the start of the session. If the parameter is not in the parameter file, the value from the default parameter file is displayed.

By specifying properties, you can limit what is displayed.

If not all parameters can be displayed due to the limited size of the reply packet, use param_directgetallnext to display the remaining content of the parameter file.

See also:

Concepts of the Database System, Database Parameters

Prerequisites

You have the server authorization ParamRead.

Syntax

param_extgetall [<property_list>]

<property_list>:: = <property_definition> <property_definition> ...

<property_definition>:: = <property>=<value> | <property>=<value,value,...>

Options

Option

Description

<property>

Property of the parameter,

must be specified in upper case.

If you enter several properties, then only those parameters that correspond to all the criteria are output (AND operator). Each property can only be specified once. If the same property is entered more than once, the value of the last entry is used for the search.

<value>

Value of the property,

must be specified in upper case.

You can enter one or more values for each property (OR operator). These are separated by commas.

See also:

Concepts of the Database System, Properties of Database Parameters

Reply

OK

<parameter_name> <type> <value>

<parameter_name> <type> <value>

...

Values for the Reply Fields

Value

Description

<parameter_name>

Name of the parameter

<type>

Data type of the parameter

<value>

Parameter value

In the event of errors, see Reply Format.

Example

Log on to the Database Manager CLI as operator OLEG with password MONDAY, connect to the DEMODB database instance, display all the parameters that cannot be changed and are assigned to the General – General Database Parameters group

>dbmcli –u OLEG,MONDAY –d DEMODB param_extgetall CHANGE=NO GROUP=GENERAL

OK

KERNELVERSION                           string  KERNEL    7.6.00   BUILD 009-103-092-650

INSTANCE_TYPE                           string  OLTP