Procedure documentation Checking All Database Parameters Locate the document in its SAP Library structure

Use

You check the entirety of all database parameters using the properties, calculation formulas, and conditions stored in the description file (Configuring Database Instances).

Prerequisites

You have created a parameter session.

You have the DBM operator authorization ParamCheckWrite.

Syntax

param_checkall [<mode>]

Option <mode>

Using the parameter <mode>, you can control the behavior of the Database Manager for parameters with the check status request.

Possible values of <mode>:

No entry

The system default values are used for all parameters (necessary for background processing).

GENERAL

Only the parameters from the group General - General Database Parameters are requested during the check status request.

EXTENDED

Only the parameters from the groups General – Structure linkGeneral Database Parameters and Extended - Structure linkSpecial Database Parameters are checked.

SUPPORT

This option is only relevant for Structure linkSAP DB Support. All parameters (General, Extended, and Support groups) are checked (Structure linkSupport Database Parameters).

Reply

If an error occurs the database parameter check is canceled with an error message.

ERR
14,ERR_XPCHECK_CN00 : param check failure/request
<parameter_name> <check_status>
<user_value>
<computed_value>

<parameter_name>

Name of database parameter

<check_status>

The following are possible values for the check status:

Mandatory – An obligatory parameter has been assigned a blank value.

Constraint – a constraint could not be fulfilled.

Request – the operator input deviates both from the value transferred to the system and confirmed by it earlier, as well as from the system default value.

<user_value>

Value that the operator entered with param_put.

<computed_value>

Default value calculated by the system

Note

For open requests the parameter changes cannot be confirmed (Confirming Changes to the Database Parameter File).

Continuation of Procedure

Correct the parameter in question using param_putconfirm (parameter correction) or param_put (change a parameter value)and carry out a new check with the command param_checkall [<mode>].

The new parameter value is registered by the system, and is transferred to the parameter file as the valid value at the next Structure linkrestart of the database instance.