Background documentationparam_getfull Locate this document in the navigation structure

 

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

Prerequisites

You have the server authorization ParamRead.

Structure

param_getfull <parameter_name>

Options

Option

Description

<parameter_name>

Name of the database parameter

Result

OK

<type>

<default> <value>

<property> <value>

<property> <value>

... HELP <help_line>

<help_line>

... EXPLAIN <explain_line>

<explain_line>

...

Values for the Reply Fields

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.

Example

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

More Information

Database Administration, Database Parameters