how do you resolve -805?
Answers were Sorted based on User's Feedback
Answer / pratap
-805 DBRM OR PACKAGE NAME
location-name.collection-id.dbrm-name.consistency -token NOT
FOUND IN PLAN plan-name. REASON reason. Suggestion: Ensure
COLLECTION name is in DB2 PLAN. Recompile and BIND the DB2
program. Verify correct LOAD library is being used.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / siri
-805 :- PLAN not found....
RESOLVE :- given the correct plan name....
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / vinay
The module needs to be binded. compile the module with
binding step in it.
| Is This Answer Correct ? | 1 Yes | 3 No |
how can we retrieve the 100 records of the file ?
What is the clustering index in the db2 database?
What are the three DB2 date and time data types and their associated functions?
When can an insert of a new primary key value threaten referential integrity?
what are the SQL codes u freequently got?
Is ibm db2 open source?
How to create backup table in db2?
wht is d/f between union and joins ?
What is the maximum number of columns in a db2 table?
what is difference between Plan and Package
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?