we can set using the command:
<b>db2 update db cfg for <db name> using MAXAPPLS <value></b>
Example:
bash-3.00$ db2 update db cfg for DBQA using MAXAPPLS 1
SQL5153N The update cannot be completed because the following relationship
would be violated: “maxappls * maxlocks >= 100”.
bash-3.00$ db2 update db cfg for DBQA using MAXLOCKS 101
SQL5130N The value specified for the configuration parameter “maxlocks” is
not in the valid range of “1” to “100”.
bash-3.00$ db2 update db cfg for DBQA using MAXLOCKS 100
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
bash-3.00$ db2 update db cfg for DBQA using MAXAPPLS 1
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
bash-3.00$
————————–
If on DB2 for z/OS this is controlled in the ZPARMS (in job DSNTIJUZ) , parms in question are MAXDBAT & CONDBAT (I think).
meandyou
Discuss This Question: