If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > SQL0805N Package "NULLID.SQLLD005" was not found

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-21-05, 22:02
Srivara Srivara is offline
Registered User
 
Join Date: Dec 2005
Posts: 1
SQL0805N Package "NULLID.SQLLD005" was not found

Hi,
I have got this error many time.
"Error Exception : System.Data.OleDb.OleDbException: [DB2/NT] SQL0805N Package "NULLID.SQLLD005" was not found. SQLSTATE=51002
CLI0129E No more handles. SQLSTATE=HY014"

The number of "NULLID.SQLLD???" is sometime changed to 003, 004 or 007.
I have got it since we move to new database server which is installed db2 same version.
My DBA tried to re-bind but I have still got it.IBM DB2 support said it hard to find out.
How could the application developer like me solve this?
Thanks.
Reply With Quote
  #2 (permalink)  
Old 12-22-05, 01:54
ggnanaraj ggnanaraj is offline
Registered User
 
Join Date: Aug 2002
Location: Chennai, India
Posts: 171
Quote:
Originally Posted by Srivara
Hi,
I have got this error many time.
"
CLI0129E No more handles. "

How could the application developer like me solve this?
Thanks.
Check this out...

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.

HTH.
Reply With Quote
  #3 (permalink)  
Old 12-22-05, 02:34
bala_e bala_e is offline
Registered User
 
Join Date: Jan 2004
Posts: 49
Try to bind the utilities in the client as like below,

db2 "bind @db2ubind.lst blocking all grant public"
db2 "bind @db2cli.lst blocking all grant public"

With Regards

Bala
Reply With Quote
  #4 (permalink)  
Old 12-23-05, 13:27
Benjamin_li Benjamin_li is offline
Registered User
 
Join Date: Mar 2005
Posts: 3
I have met the same problem before. The solution is what Bala said.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On