How to limit the number of application connections in DB2?

455 pts.
Tags:
DB2
DB2 administration
DB2 configuration
DB2 connectivity
DB2 Universal Database
I want to limit the number of application connections to 1 in DB2 server. And try connecting with 2 applications to check the behavior?

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following