By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,590 Members | 2,174 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,590 IT Pros & Developers. It's quick & easy.

DB2 Configuration

P: 1
hi guys

i m new to DB2. i do not have any DB2 adminstration idea. if someone can describe my questions i will b thankful to him.

1. How can we maintain the connection pooling in the DB2(possible ways).
2. what r the maintenance issues with it.
3. How can we maintain the load balancing if the 300 user connect at the same time. what will b the issue.

Thanks in Advance

Shahid Malhi
Mar 29 '07 #1
Share this Question
Share on Google+
1 Reply

P: 10

Assuming you are using DB2 UDB, here are the answers.

1. Connection pooling can be done at instance level by using dbm cfg parameter NUM_POOLAGENTS. If you give a value of 200, then 200 agents will be residing in the pool for future use.

2. The pool will be maintained by db2 itself. You need to decide on the number of agents in pool, more number of agents in the pool means more memory they occupy. You can also use NUM_INITAGENTS dbm cfg to initially allocate some agents in the pool.

3. For 300 concurrent users, you should have the value of MAXAGENTS to atleast 300. Because one connection might initiate sub agents. 400 to 500 could be the value of MAXAGENTS. You should have enough memory available to allocate those many agents and as usual CPU.

Mar 29 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Browse more DB2 Database Questions on Bytes