Interested to Buy Any Domain ? << Click Here >> for more details...
How to resolve -805 error in DB2?
- 1 Answers
- 36079 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 restart?
What do you mean by commit and rollback?
How do I copy a table in db2?
How to view db2 table structure?
What is a result table?
How would the varchar column remarks defined?
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
What is a Resource Control Table(RCT)? Describe its characteristics.
What is dbrm?
What is a storage group (stogroup)?
What is DCLGEN?
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
COBOL 
