do a select unique_id, pkgname from syscat.packages

UNIQUE_ID PKGNAME

--------- -----------
---------------------
zAtESRCU P8044533

and then do a browse of your executable, do a find on the zAtESRCU (or
whatever you get on your query) Thats what has to be in your
executable.

If its not there, then your compile / bind is not correct.






"Gard Joe
\(CBC\) "
<db2udbdba-ezmlms To
hield-x32193718.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc

01/20/2006 02:18 Subject
PM sqlerror 805











Does anyone know of a way to help figure out this error .. I have a valib
compile , link and bind .. I keep getting the -805 when I run the program
... I did check the package catalog tables and the plan/package and
collection seem to be there ...



DBRM OR PACKAGE NAME location-name.collection-id.dbrm-name.consistency
-token NOT FOUND IN PLAN plan-name. REASON reason
Explanation:
An application program attempted to use a DBRM or package
'location-name.collection-id.dbrm-name.consistency-token' that was not
found.


Confidentiality Notice:
This e-mail is intended only for the personal and confidential use of the
individual to whom it is addressed and may contain information that is
privileged, confidential and protected by law. If you are not the intended
recipient, you are hereby notified that any use or disclosure of this
information is strictly prohibited. If you have received this message in
error, please notify the sender immediately by reply e-mail and delete the
original message. Your compliance is appreciated.




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page