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 |
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
Mention the definition of cobol in varchar field.
How to design maps
What does db2 blu stand for?
What is PRIME TABLE and what are the uses of it
What is nvl in db2?
Outputs of explain are with matchcols = 0. What does this signify?
how to get duplicate records from tables?write qurey for this?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
How do I delete a table in database?
what is check point and restart Logic ? why do we go for that ??
how to resolve -805. give clear explination for that