How to limit the number of application connections in DB2?

455 pts.
Tags:
DB2 administration
DB2 connectivity
IBM 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: Last updated:
Related Questions
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

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:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: