Q:
How to limit the number of application connections in DB2?
I want to limit the number of application connections to 1 in DB2 server. And try connecting with 2 applications to check the behavior?
ASKED:
Dec 8 2008 10:54 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
db2 update db cfg for <db name> using MAXAPPLS <value>
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
