Properties of Database Parameters

Use

Beyond its current value, every database parameter also has other properties. These properties are defined in the default parameter file cserv.pcf (see Configuration Files).

Changes to database parameters do not take effect until the database instance is restarted.

You can also change some database parameters while the database is running. In addition you can choose how long the change is to be effective for these database parameters:

¦      Until the next restart

¦      Not until after the next restart

¦      Immediately and permanently

Properties of Database Parameters

Property

Permitted Values

Description

CASESENSITIVE

YES | NO

The database system observes lowercase and uppercase for the values.

CHANGE

NO | RUNNING | OFFLINE

Specifies whether and in which operational state the parameter can be changed

NO = cannot be changed

RUNNING = changeable in the operational states ONLINE and ADMIN; you can choose when the change takes effect

OFFLINE = the new value only takes effect after a restart

CLEAR

YES | NO

Specifies whether the parameter can be adopted in a new database instance (e.g. NO for the parameter RUNDIRECTORY)

DEVSPACE

YES | NO

Type of parameter:

YES = Volume parameter

NO = Kernel parameter

DISPLAYNAME

Character string, may contain blank characters

Name for the parameter displayed in the Database Manager GUI

DYNAMIC

YES | NO

Specifies whether there are placeholders for the parameter (e.g. DATAVOL_?) in the default parameter file

GROUP

GENERAL | EXTENDED | SUPPORT | NO | TRACE

Group to which the parameter belongs:

GENERAL: General Database Parameters

EXTENDED: Special Database Parameters

SUPPORT: Support Database Parameters

NO: Parameter is not displayed in the Database Manager GUI

TRACE: Parameter for the database trace, database check and monitoring

INSTANCES

LVC | OLTP

Database instance for which the parameter is relevant:

LVC = SAP liveCache

OLTP = OLTP (MaxDB)

Not specified: Valid for all database instance types

INTERN

YES | NO

Specifies whether the value is required for internal calculations

LASTKNOWNGOOD

Last valid value (value that the parameter had the last time the database instance was started successfully)

MANDATORY

YES | NO

Specifies whether the parameter has to have a value (non-zero or not empty)

MAX

Maximum Value

MIN

Minimum value

MODIFY

YES | NO

Specifies whether you can still change the parameter after the database instance has been created (e.g. NO for the parameter RUNDIRECTORY)

VALUESET

The individual values have to be separated from each other by blank characters or tabs.

For character string parameters, the permitted character string constants have to be placed in quotation marks.

Value set

Example

As operator DBADMIN with the password SECRET, you use the Database Manager CLI to display the properties of the parameter RUNDIRECTORY for the database instance DEMODB:

dbmcli –d DEMODB –u DBADMIN,SECRET param_getproperties RUNDIRECTORY

OK

CHANGE  OFFLINE

INTERN  NO

MANDATORY       YES

CLEAR   YES

DYNAMIC NO

CASESENSITIVE   YES

DEVSPACE        NO

MODIFY  YES

GROUP   GENERAL

DISPLAYNAME

VALUESET

MAX

MIN

INSTANCES