param_commitsession 
Use this DBM command to confirm changes you have made to database parameters and to enter them in the database parameter file. Only execute this DBM command if you have successfully executed the command for checking all database parameters.
You can enter an option to define if you would like the parameter session to remain open or to be closed once the changes have been confirmed.
The changed values in the parameter file become only effective after a restart of the database.
Prerequisites
You have changed the parameter values during a parameter session param_startsession.
The check of the parameters you changed was successful (see: param_checkall).
You have the server permission ParamCheckWrite.
Structure
param_commitsession [NOCLOSE]
Option |
Description |
|---|---|
NOCLOSE |
The parameter session remains open after the database parameters have been saved. |
Result
OK
Reply in the Event of an Error
ERR 14,ERR_XPCHECK_CN00 : param check failure/request <parameter_name> <check_status> <user_value> <computed_value>
Value |
Description |
|---|---|
<parameter_name> |
Name of the database parameter |
<check_status> |
Check result Possible values are: mandatory | constraint mandatory: An obligatory database parameter has not been defined. constraint: A condition defined in the default parameter file was not fulfilled. |
<user_value> |
Value defined by the user for the database parameter |
<computed_value> |
Default value calculated by the system |
More Information
Database Administration, Database Parameters