SetCLI0129E No more handles. SQLSTATE=S1014

mann madhan · #1 (**permalink**) 03-15-11, 15:07

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

ARWinner · #2 (**permalink**) 03-15-11, 15:15

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

mann madhan · #3 (**permalink**) 03-15-11, 15:21

sorry ARWinner,

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

ARWinner · #4 (**permalink**) 03-15-11, 15:24

How are you interfacing with the DB2 CLI?

Andy

mann madhan · #5 (**permalink**) 03-15-11, 15:27

i am using only odbc connection

Marcus_A · #6 (**permalink**) 03-15-11, 15:27

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.

mann madhan · #7 (**permalink**) 03-15-11, 15:29

i am using vc++

Marcus_A · #8 (**permalink**) 03-15-11, 15:33

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.