Hey Joe,
You need to look at the timestamps for your load module and for your
DBRM/package. Maybe you grabbed the wrong DBRM when you did your bind. Or ,
maybe you are grabbing the old Load module when you are executing your
program. Every time that I have seen this, it is that the timestamps don't
match between the load module and the DBRM for whatever reason.

Jim McGuire
email JIM.[Email address protected]



-----Original Message-----
From: Gard Joe (CBC)
[mailto:db2udbdba-ezmlmshield-x32193718.[Email address protected]
Sent: Friday, January 20, 2006 2:19 PM
To: LazyDBA Discussion
Subject: 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