[IBM][CLI Driver] SQL1226N The maximum number of client connections are already started.

I have a function in java EJB that does a mass add of logs into the database. But, it gives this error. Is there a way to increase the number of client connection?

I'm using a DB2 v8

Thanks in advance.

Thanks but i manage to resolve it

On Windows:

Find out maxagents on database manager level
get dbM cfg | find "(MAXAGENTS)"

Find out maxappls for database
get db cfg for <database> | find "(MAXAPPLS)"
write database name for <database>

Change dbm parameter if needed
UPDATE DBM CFG USING MAXAGENTS <number>
write number for <number>

Change db parameter for <database>
UPDATE DB CFG FOR SAMPLE USING MAXAPPLS <number>
write number for <number>


For Unix systems replace 'find' with 'grep'

Increase num_initagents and num_poolagents to be larger than the database connection pool that you've defined in Websphere.

num_initagents pre-creates db2 agent processes (which speeds up connection times).

num_poolagents keeps the db2 agent processes active when a db2 connection is terminated.

Both of these parameters will substantially improve performance in a web environment (since in such an environment a connection is typically initiated and terminated for each transaction)