Background documentationparam_extgetall Locate this document in the navigation structure

 

With this command you can display the data of all database parameters from the database parameter file and the default parameter file.

For each parameter, the system displays the name, the data type, and the current value, which 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_extgetallnext to display the remaining content of the parameter file.

Prerequisites

You have the server permission ParamRead.

Structure

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,

to 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 last value entered is used for the search.

<value>

Value of the property,

to be specified in upper case.

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

Result

OK

<parameter_name> <type> <value>

<parameter_name> <type> <value>

...

Values for the Reply Fields

Value

Description

<parameter_name>

Name of the database parameter

<type>

Data type of the database parameter

<value>

Current value

In the event of errors, see Reply Format.

Example

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

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

OK

KernelVersion string KERNEL 7.7.02 BUILD 004-103 -136-991

InstanceType string OLTP

More Information

Database Administration, Database Parameters