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


You have the server authorization ParamRead.


param_extgetall [<property_list>]

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

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





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



<parameter_name> <type> <value>

<parameter_name> <type> <value>


Values for the Reply Fields




Name of the parameter


Data type of the parameter


Parameter value

In the event of errors, see Reply Format.


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


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

INSTANCE_TYPE                           string  OLTP