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 db2 connect?
What are the three DB2 date and time data types and their associated functions?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What is multi row fetch in db2?
how we will do null data selection in cobol-db2 program
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
how can u nderstand the sql stmts executed successfully or not ?
What is a cursor and what is its function?
can any one expalin check point with an example?
What is the information associated with sysibm.syslinks table?
What is CHECK PENDING ?
What is difference between alias and synonym in db2?