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 check constraint. Explain with example.
What is dbrm?
What is syscat in db2?
What is the difference between dbm cfg and db cfg file in db2 ?
What is the syntax for creating a table in the db2 database?
What is dpf in db2?
What is a LIKE table and how is it created?
What is the advantage in De-normalizing tables in DB2?
What is bufferpool in db2?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
How can you quickly find out the # of rows updated after an update statement?
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)