param_extgetall 
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_extgetallnext to display the remaining content of the parameter file.
Prerequisites
You have the server authorization ParamRead.
Structure
param_extgetall [<property_list>]
<property_list>:: = <property_definition> <property_definition> ...
<property_definition> :: = <property>=<value> | <property>=<value,value,...>
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 last value entered 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. |
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 |
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 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