No more handles error message

Dave Schaeffer

No more handles error message
I upgraded to the latest version of Visual Explain and for a hand full
of SQL
statements I get the following error message:

The input SQL statement can not be executed : SQLCODE=-99999
[IBM][CLI Driver] CLI0129E No more handles. SQLSTATE=HY014

Has anyone run into this with Visual Explain? If so how did you work
around
this error?

Also is there a place to download a prior version of Visual Explain?

Thank you for any Help!

Dave Schaeffer

---------------------------------------------------------------------------------
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

harby ariza

Re: No more handles error message
(in response to Dave Schaeffer)
_______________________________________________________________________________________

Note: This e-mail is subject to the disclaimer contained at the bottom of this message.
_______________________________________________________________________________________





What version of DB2 are you running?. I remember we ended up migrating
from db2 v7 to v8 because of this error.

harby



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of [login to unmask email]
Sent: Friday, 12 January 2007 7:22 AM
To: [login to unmask email]
Subject: [DB2-L] No more handles error message

I upgraded to the latest version of Visual Explain and for a hand full
of SQL
statements I get the following error message:

The input SQL statement can not be executed : SQLCODE=-99999
[IBM][CLI Driver] CLI0129E No more handles. SQLSTATE=HY014

Has anyone run into this with Visual Explain? If so how did you work
around
this error?

Also is there a place to download a prior version of Visual Explain?

Thank you for any Help!

Dave Schaeffer

------------------------------------------------------------------------
---------
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

_______________________________________________________________________________________

The information transmitted in this message and its attachments (if any) is intended
only for the person or entity to which it is addressed.
The message may contain confidential and/or privileged material. Any review,
retransmission, dissemination or other use of, or taking of any action in reliance
upon this information, by persons or entities other than the intended recipient is
prohibited.

If you have received this in error, please contact the sender and delete this e-mail
and associated material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or distribute
the information contained in this e-mail and any attached files, with the permission
of the sender.

This message has been scanned for viruses with Symantec Scan Engine and cleared by
MailMarshal.
_______________________________________________________________________________________

---------------------------------------------------------------------------------
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