Results 1 to 4 of 4

Thread: Cli0129e

  1. #1
    Join Date
    Oct 2002
    Posts
    2

    Unanswered: Cli0129e

    In a high volume transaction environment I have a servlet
    read/write operations on a database for each time that it is called. When using a low transaction rate everything works just fine. However, when stressing the system DB2 comes back with the following message:
    IBM][CLI Driver] CLI0129E No more handles. SQLSTATE=HY014.

    How can I resolve this problem?

  2. #2
    Join Date
    Nov 2002
    Location
    Austria
    Posts
    1

    Arrow

    We've had the same problem in our WAS 3.5 / DB2Connect V7.2 FP4 environment.

    Now we have moved to FP7 and things got a lot better but the CLI129E still occured.

    Now we installed an a special fixed which was recommended by db2 lab.

    The download address for this fix is

    ftp://testcase.boulder.ibm.com/ps/fr...ial_6178.tar.Z

    This can be really risky because this fix was specialy made to solve our problem but if you have a test environment you should try it out.

    Installation Instruction:
    The ZIP files contains the following files

    lib/libdb2e.a
    lib/libdb2.a
    lib/libodbc.a
    lib/db2.o
    lib/db2_36.o
    bin/db2level

    You have to:
    - db2stop for all instance
    - check with "ipclean" if all db2 processes have stopped
    if not try db2_kill as instance owner
    - stop the db2 administration server
    - save all fixes files before replacing them
    /usr/lpp/db2_07_01/lib und /usr/lpp/db2_07_01/bin an
    - replace the files
    if you start db2 again db2level should produce the following output

    DB21085I Instance "wsdb2" uses DB2 code release "SQL07025" with level
    identifier "03060105" and informational tokens "DB2 v7.1.0.68",
    "special_6178"
    and "U484480_6178".

    I hope this information is usefull to you

  3. #3
    Join Date
    Oct 2002
    Posts
    2

    FixPack for Win 2000

    Where can I find this FixPack for Windows 2000 Proffecional?

  4. #4
    Join Date
    Nov 2002
    Posts
    14

    Re: Cli0129e

    Check the Database Configuration parameter (MAXAPPLS). The default is 40 and you may be hitting that thresehold. Once you reach that value any additional connections to the database are refused. You may have to either increase that value or make sure the servlet is releasing the db connections after it is done using it. Hope that helps.



    Originally posted by Tano
    In a high volume transaction environment I have a servlet
    read/write operations on a database for each time that it is called. When using a low transaction rate everything works just fine. However, when stressing the system DB2 comes back with the following message:
    IBM][CLI Driver] CLI0129E No more handles. SQLSTATE=HY014.

    How can I resolve this problem?

Posting Permissions

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