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 |
wht happens if we close cursor with cursor with hold option?
Explain dclgen.
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
What is a result table?
what is the input to PLAN? what is the input to DBRM?
How would you print the output of an SQL statement from SPUFI?
Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?
What is the logical entity between plan and Package?
What is runstats db2?
Discuss about db2 bind?
When do you use the IMAGECOPY?
What is pagespace?