Toad World® Forums

Recommended settings for connection pooling in DB2


#1

Hi,

Users of our application are getting the below errror:
Error:ERROR [57030] [IBM][CLI Driver] SQL1226N The maximum number of client connections are already started. SQLSTATE=57030 ERROR [57030] [IBM][CLI Driver] SQL1226N The maximum number of client connections are already started.

When I tried to research it found out that the error is caused because of connection pooling and following settings can be changed in DB2 to troubleshoot the error:

MAXAPPLS
MAXAGENTS
MAX_CONNECTIONS
MAX_COORDAGENTS
NUM_POOLAGENTS
NUM_INITAGENTS
(MAX_COORDAGENTS) = MAXAGENTS
(MAXCAGENTS) = MAX_COORDAGENTS
(MAX_CONNECTIONS) = MAX_COORDAGENTS

Can anyone suggest the recommended settings for the above items, for enterprise wide application with thousands of users.

Thanks !
Siddhesh.


#2

There are many factors that are related to determining the best settings in each environment. I would recommend that you refer to IBM documentation on this topic including, but not limited to:

www-01.ibm.com/…/r0052306.html

and

http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.config.doc/doc/c0009674.html?cp=SSEPGG_10.5.0%2F2-4-4-2