How to resolve -805 error in DB2?



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

Post New Answer

More DB2 Interview Questions

What is explain plan in db2?

0 Answers  


What is a db2 schema?

0 Answers  


What is query for your birthday date should be in hours,minute and seconds format?

1 Answers   Fidelity,


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

0 Answers  


What is dynamic SQL?

1 Answers   ADP,


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?

1 Answers  


Explain an outer join?

1 Answers  


What is a cursor?

2 Answers  


What information is used as input to the bind process?

2 Answers  


Explain in detail about buffer manager and its functionalities?

0 Answers  


what is difference between Plan and Package

1 Answers   Syntel,


what's the best lock size that you could use when you create a tablespace?

2 Answers   IBM,


Categories