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