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.
You can find the prerequisites under Database Manager CLI, param_startsession
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>
Open a parameter session
dbmcli on DEMODB>param_startsession
OK
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
Have the database system start checking the database parameters:
dbmcli on DEMODB>param_checkall
OK
Confirm the changes made to the database parameter file:
dbmcli on DEMODB>param_commitsession
OK
The parameter values were changed. The changes are not yet effective during the current database session; they only become valid after a database restart.