How to resolve -805 error in DB2?
Answer / lakshmi
Reason for Sql Code -805: The application program attempts
to use a DBRM package that is not found ('location-
name.colection-id.dbrm-name.consistency-token').
Solution:
1. Rebind the program with the correct DBRM library name.
2. The plan name used in the JCL and the plan used for bind
should be same.
Is This Answer Correct ? | 39 Yes | 3 No |
What is explain plan in db2?
What is a db2 schema?
What is query for your birthday date should be in hours,minute and seconds format?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is dynamic SQL?
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
Explain an outer join?
What is a cursor?
What information is used as input to the bind process?
Explain in detail about buffer manager and its functionalities?
what is difference between Plan and Package
what's the best lock size that you could use when you create a tablespace?