MaxDB Change Parameter MAXUSERTASKS

1. To check db status

dbmcli -u superdba,xxxx -d DBTEST db_state

2. To check the current value of MAXUSERTASKS

dbmcli -u superdba,xxxxxx -d DBTEST param_getvalue MAXUSERTASKS

3. To bring down application
dbmcli -u superdba,xxxxxx -d DBTEST db_offline

4. To modify the parameter MAXUSERTASKS
dbmcli -u superdba,xxxxxx  -d DBTEST  param_put MAXUSERTASKS 500

5. To bring up the MaxDB database
dbmcli -u superdba,xxxxxx -d DBTEST db_online



6. To verify and confirm the parameter changes

dbmcli -u superdba,xxxxxxx -d DBTEST param_getvalue MAXUSERTASKS