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?
Software/Hardware used:
Software/Hardware used:
ASKED:
December 8, 2008 10:54 AM
UPDATED:
September 23, 2009 3:59 PM
Answer Wiki:
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
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
