You display the further database parameters from the parameter file of the database instance and default parameter file. By specifying properties, you can limit what is displayed. However, you can specify each property only once. If the same property is entered more than once, the value of the last entry is used.
A parameter must match the relevant value in all the specified properties (AND link). Several values for one property separated by commas are treated as an OR link.
See also:
Properties of Database Parameters
The reply 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 default value from the default parameter file is displayed.
· You have executed the DMB command for displaying the data for all database parameters. Since the size of the reply memory is limited, not all of the values are displayed.
· You have the server authorization ParamRead.
param_extgetallnext [<property>=<value>]
Option |
Description |
<property> |
Property of the parameter |
<value> |
Value of the property |
OK<NL>
<parameter_name> <type> <value><NL>
<parameter_name> <type> <value><NL>
...
Values for the Fields of the Reply
Value |
Description |
<parameter_name> |
Name of the parameter |
<type> |
Data type of the parameter |
<value> |
Value of the parameter |
In the event of errors, see Reply Format.
Logging on to the Database Manager CLI as the operator DBM with the password DBM, connecting to the database instance HOTELDB, and displaying all parameters that cannot be changed and that are assigned to the General - General Database Parameters group
dbmcli –u DBM,DBM –d HOTELDB param_extgetallnext