Results 1 to 11 of 11
  1. #1
    Join Date
    Mar 2010
    Posts
    15

    Unanswered: SetCLI0129E No more handles. SQLSTATE=S1014

    Dear team,

    i am receiving "SetCLI0129E No more handles. SQLSTATE=S1014" kindly tell me why i am receiving this error and how i have to fix it.kindly help me

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Straight from the manual:

    Code:
    CLI0129E  No more handles.
    
    Explanation:
    
    A call was made to SQLAllocEnv, SQLAllocConnect, SQLAllocStmt,
    SQLExecute, or SQLExecDirect but no more handles are available in the
    driver.
    
    User response:
    
    Call SQLFreeEnv, SQLFreeConnect, or SQLFreeStmt to free up some handles
    which are no longer being used in the application.
    Andy

  3. #3
    Join Date
    Mar 2010
    Posts
    15

    new bie

    sorry ARWinner,

    actually . i am developing a new application in db2. i don't know how to free the resource

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    How are you interfacing with the DB2 CLI?

    Andy

  5. #5
    Join Date
    Mar 2010
    Posts
    15

    only odbc

    i am using only odbc connection

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I believe that it means that DB2 has run out of large cursor packages that can be used at one time. A DBA can rebind the package involved to increase it up to about 30, but that is like giving more drugs to a drug addict since it does not solve the underlying problem.

    The problem is that your programs are not closing connections properly in their code, and/or are not committing frequently enough. See the Developing Java Applications or Developing ADO.NET and OLE DB Applications manuals for more information.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  7. #7
    Join Date
    Mar 2010
    Posts
    15

    vc++

    i am using vc++

  8. #8
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I modified my response to include the Developing ADO.NET and OLE DB Applications. But you should know how to do more frequent commits, and/or close transactions.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  9. #9
    Join Date
    Mar 2010
    Posts
    15
    sure i will do that and confirm you soon

  10. #10
    Join Date
    Mar 2010
    Posts
    15
    the issue is raising mostly in select query ?

  11. #11
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by mann madhan View Post
    the issue is raising mostly in select query ?
    That is not unusual. Too many cursors open at one time (DB2 usues cursors behind the scenes to process answer sets).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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