You display all the data stored for the database parameter specified.
You have the server authorization ParamRead.
param_getfull <parameter_name>
Option |
Description |
---|---|
<parameter_name> |
Name of the database parameter |
OK
<type>
<default> <value>
<property> <value>
<property> <value>
... HELP <help_line>
<help_line>
... EXPLAIN <explain_line>
<explain_line>
...
Value |
Description |
---|---|
<type> |
Data type of the parameter |
<default> |
System default value |
<value> |
Current value taken from the parameter file at the start of the session |
<property> |
Property of the parameter |
<help_line> |
Help text |
<explain_line> |
Explanatory text |
In the event of errors, see Reply Format.
Call the Database Manager CLI, log on as operator OLEG with password MONDAY, connect to the database instance DEMODB, display all data of the database parameter RunDirectoryPath:
>dbmcli -u OLEG,MONDAY -d DEMODB param_getfull RunDirectoryPath
OK
string
c:\documents and settings\all users\application data\sdb\data\wrk\DEMODB
CHANGE OFFLINE
INTERN NO
MANDATORY YES
CLEAR YES
DYNAMIC NO
CASESENSITIVE YES
DEVSPACE NO
MODIFY YES
GROUP GENERAL
DISPLAYNAME
VALUESET
MAX
MIN
INSTANCES
SYSDBAONLY YES
CLASS GENERAL
LASTKNOWNGOOD c:\documents and settings\all users\application data\sdb\data\wrk\DEMODB
ACTIVEVALUE c:\documents and settings\all users\application data\sdb\data\wrk\DEMODB
HELP
Path where context and diagnosis information is stored
EXPLAIN
Path where context and diagnosis information is stored for this database instance.
(char(256))
Database Administration, Database Parameters