Procedure documentationChanging the Values of Multiple Database Parameters Locate this document in the navigation structure

 

To change multiple database parameters, you first explicitly open a parameter session. In this parameter session you can assign a new value to each of the parameters and have the system check the new parameter values. You then confirm the changes made to the parameter file.

You can define if you would like the parameter session to remain open or to be closed once the changes have been confirmed.

Prerequisites

You can find the prerequisites under Database Manager CLI, param_startsession

param_put

param_checkall

param_commitsession

Procedure

  1. Call Database Manager CLI in session mode, log on as operator OLEG with the password MONDAY, and connect to the database DEMODB:

    >dbmcli –u OLEG,MONDAY –d DEMODB

    dbmcli on DEMODB>

  2. Open a parameter session

    dbmcli on DEMODB>param_startsession

    OK

  3. Change the parameter value for MAXUSERTASKS to 5, for MAXLOCKS to 2000, and for CACHE_SIZE to 8000.

    You want the new values for the parameters to become effective only after a restart. (There is no need to enter the corresponding option –permanent as this is the system default):

    dbmcli on DEMODB>param_put MAXUSERTASKS 5

    OK

    dbmcli on DEMODB>param_put MAXLOCKS 2000

    OK

    dbmcli on DEMODB>param_put CACHE_SIZE 8000

    OK

  4. Have the database system start checking the database parameters:

    dbmcli on DEMODB>param_checkall

    OK

  5. Confirm the changes made to the database parameter file:

    dbmcli on DEMODB>param_commitsession

    OK

Result

The parameter values were changed. The changes are not yet effective during the current database session; they only become valid after a database restart.