param_getfull 

Use

You display all the data stored for the database parameter specified.

See also:

Concepts of the Database System, Database Parameters

Prerequisites

You have the server authorization ParamRead.

Syntax

param_getfull <parameter_name>

<parameter_name>

Name of database parameter

Reply

OK

<type>

<default> <value>

<property> <value>

<property> <value>

...
HELP
<help_line>

<help_line>

...
EXPLAIN
<explain_line>

<explain_line>

...

Values for the Reply Fields

Field	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 See also: Concepts of the Database System, Properties of Database Parameters
<help_line>	Help text
<explain_line>	Explanatory text

 

In the event of errors, see Reply Format.

Example

Call the Database Manager CLI, log on as operator OLEG with password MONDAY, connect to the database instance DEMODB, display all data for the database parameter RUNDIRECTORY:

>dbmcli -u OLEG,MONDAY -d DEMODB param_getfull RUNDIRECTORY

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