Show TOC

param_extgetallLocate this document in the navigation structure

Use

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 [-long][<property_list>]

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

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

Table 1: Options

Option

Description

-long

Displaying the extended output for each parameter

<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>

...

Value

Description

<parameter_name>

Name of the database parameter

<type>

Data type of the database parameter

<value>

Current value

If you use the -long option, the following output per parameter could be displayed:

ID PAREMETERNAME

TYPE int

ACTIVEVALUE 8

DEFAULTVALUE 1

GROUP EXTENDED

CHANGE OFFLINE

HELP information about the parameter

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