You check all the database parameters using the properties, calculation formulas, and conditions stored in the description file (Configuration of Database Instances).
You have opened a parameter session.
You have the server authorization ParamCheckWrite.
param_checkall [<mode>]
You use the <mode>parameter to control the behavior of the Database Manager for parameters with the check status request.
Possible values for <mode>:
No entry |
The system default values are used for all parameters (necessary for background processing). |
GENERAL |
Only the database parameters in the General – General Database Parameters are requested with the request check status. |
EXTENDED |
Only the parameters in the General Database Parameters (General) and Special Database Parameters (Extended) are checked. |
SUPPORT |
This option is only relevant for Support. All parameters (from the groups General, Extended, and Support) are checked. |
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 the database parameter |
<check_status> |
The following are possible values for the check status: Mandatory – a mandatory parameter has been assigned a blank value. Constraint – a constraint could not be fulfilled. Request – the operator input deviates both from the value that was transferred earlier to and confirmed by the system, and from the system default value. |
<user_value> |
Value that the operator entered with param_put. |
<computed_value> |
Default value calculated by the system |
The parameter changes cannot be confirmed for open requests (Confirming Changes to the Database Parameter File).
Correct the parameter in question using param_putconfirm (Parameter Correction) or param_put (Changing a Parameter Value) and repeat the check with the param_checkall [<mode>] command.
The new value is registered by the system and transferred to the database parameter file as the effective value the next time the database instance is restarted.