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.
You have the server permission ParamRead.
param_extgetall [-long][<property_list>]
<property_list>:: = <property_definition> <property_definition> ...
<property_definition> :: = <property>=<value> | <property>=<value,value,...>
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. |
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.
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
Commands for Changing Database Parameters
Database Administration, Database Parameters
SAP Note 1139904