Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Posts
    14

    Unanswered: [IBM][CLI Driver] SQL1226N The maximum number of client connections are already star

    [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.
    Last edited by Paingiver; 01-27-05 at 02:59.

  2. #2
    Join Date
    Feb 2004
    Posts
    14
    Thanks but i manage to resolve it

  3. #3
    Join Date
    Jan 2003
    Posts
    1,605
    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'

  4. #4
    Join Date
    Aug 2004
    Location
    London, UK
    Posts
    31

    You'll also want to

    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)
    jdey@macehill.co.uk
    http://www.macehill.co.uk

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •