CLI0129E message on DB2 UDB

Helen Johnson

CLI0129E message on DB2 UDB


Hi All,



I am using DB2 UDB 7.2 on AIX. One of my programmers received a CLI0129E
message which I have never seen before. I looked it up and found the
below messages which I'm still not sure I understand. There were only 5
users on DB2 at a time of the error when I did a LIST APPLICATIONS. It
should have been able to support many more than that and I have seen
many more than that on this box concurrently. Does this message refer
to something that is happening just within the program itself or all the
programs that are running on the box at the same time?

Thanks for any insight you can provide. I haven't been able to find
much in the manuals.



CLI0129E

No more handles.

Explanation: A call was made to SQLAllocEnv, SQLAllocConnect, or
SQLAllocStmt 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.





Helen Johnson




---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Dieter Schwarz

Re: CLI0129E message on DB2 UDB
(in response to Helen Johnson)
Helen,

the error message refers to the situation on the client - not
on the server. I guess that the programmer has not
undertaken proper exception-handling (closing resources etc)
- just my $0.02. Anyway, somehow he scattered the
CLI-Driver....
re-boot the client and some debugging should fix the problem ;)

Dieter Schwarz

----- Original Message -----
From: Helen Johnson
Newsgroups: bit.listserv.db2-l
To: [login to unmask email]
Sent: Wednesday, December 22, 2004 5:41 PM
Subject: [DB2-L] CLI0129E message on DB2 UDB




Hi All,



I am using DB2 UDB 7.2 on AIX. One of my programmers received a CLI0129E message which I have never seen before. I looked it up and found the below messages which I'm still not sure I understand. There were only 5 users on DB2 at a time of the error when I did a LIST APPLICATIONS. It should have been able to support many more than that and I have seen many more than that on this box concurrently. Does this message refer to something that is happening just within the program itself or all the programs that are running on the box at the same time?

Thanks for any insight you can provide. I haven't been able to find much in the manuals.



CLI0129E
No more handles.


Explanation: A call was made to SQLAllocEnv, SQLAllocConnect, or SQLAllocStmt 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.





Helen Johnson



--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Helen Johnson

Re: CLI0129E message on DB2 UDB
(in response to Dieter Schwarz)
Thanks Dieter that was just the help the programmer needed. He can't
change the app because it is a purchased product he must go through, but
after rebooting it, everything works like it should.



Thanks again.



Helen Johnson



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of D. Schwarz
Sent: Wednesday, December 22, 2004 11:49 AM
To: [login to unmask email]
Subject: Re: CLI0129E message on DB2 UDB



Helen,



the error message refers to the situation on the client - not

on the server. I guess that the programmer has not

undertaken proper exception-handling (closing resources etc)

- just my $0.02. Anyway, somehow he scattered the

CLI-Driver....

re-boot the client and some debugging should fix the problem ;)



Dieter Schwarz



------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm