| Author |
Message
|
| HOMETOWN47 |
 Posted: Tue Mar 25, 2003 5:13 am Post subject: Remote DB Connectivity SQLState=51002 |
 |
|
Apprentice
Joined: 25 Mar 2003
Posts: 34
|
I'm writing a VB app to enable the maintenance of some DB tables. The app sends batches of SQL statements (create, update delete rows) statements to an MQ queue in an XML format. I have a simple MQSI message flow that takes the XML message off the queue and takes each SQL statement and issues a PASSTHRU command.
The whole process appears to work for a period of time but then I start gettting back the following message:-
[IBM][CLI Driver][DB2]SQL0805N Package "DB2B.NULLID.SQLLD003.6A41786351614" not found. SQLSTATE=51002.
Any ideas ? |
|
| Back to top |
|
 |
| kirani |
| Posted: Tue Mar 25, 2003 10:23 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Please see if you can find more information into DB2 log file for this problem. Could you post your ExceptionList for this error here? Is there any error logged into EventViewer on the broker machine?
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| ninjahatodi |
| Posted: Sun Feb 21, 2010 2:28 am Post subject: |
|
|
Novice
Joined: 02 Apr 2009
Posts: 12
|
I am also facing similar issue.
However error
"SQL0805N Package "NULLID.SQLE2H0V 0X414141414153425A" was not
found. sqlcode: -805
sqlstate: 51002" is returned when i am trying to create new database.
I found out from the googling what 51002 means:
51002 The package corresponding to an SQL statement execution request
was not found.
What package is it referring to? How could I suddenly (after creating two database ) need this package NULLID.SQLE2H0V 0X414141414153425A? |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sun Feb 21, 2010 4:08 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| ninjahatodi wrote: |
I am also facing similar issue.
However error
"SQL0805N Package "NULLID.SQLE2H0V 0X414141414153425A" was not
found. sqlcode: -805
sqlstate: 51002" is returned when i am trying to create new database.
I found out from the googling what 51002 means:
51002 The package corresponding to an SQL statement execution request
was not found.
What package is it referring to? How could I suddenly (after creating two database ) need this package NULLID.SQLE2H0V 0X414141414153425A? |
Not too surprised... especially if you change the location of a DB. Make sure you relink all the DB utilities ... and talk to a DBA 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| Vitor |
| Posted: Sun Feb 21, 2010 8:46 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| ninjahatodi wrote: |
| I am also facing similar issue. |
You might be facing a similar issue, but not the same one. The thread you posted on is 7 years old; software changes.
It's better to open a new thread and refer to the old one.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
