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 |
Comment whether the cursor is closed during commit or not.
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)
What is the use of value function?
What is ibm db2 database?
What is the function of buffer manager?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
Which component is responsible for db2 startup and shutdown?
Explain the contents that are a part of dclgen.
what is the difference between normal select query and currosor
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is a DB2 plan?
what is a trigger and types of triggers