how do you resolve -805?
Answers were Sorted based on User's Feedback
Answer / pratap
-805 DBRM OR PACKAGE NAME
location-name.collection-id.dbrm-name.consistency -token NOT
FOUND IN PLAN plan-name. REASON reason. Suggestion: Ensure
COLLECTION name is in DB2 PLAN. Recompile and BIND the DB2
program. Verify correct LOAD library is being used.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / siri
-805 :- PLAN not found....
RESOLVE :- given the correct plan name....
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / vinay
The module needs to be binded. compile the module with
binding step in it.
| Is This Answer Correct ? | 1 Yes | 3 No |
How do I delete a column in db2?
how to identify the pseudo conversation by seeing the program
List out the buffer pools in db2
where will u check for sqlcode ?
What db2 400?
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?
Which components manage deadlocks in db2?
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
What is the function of the Data Manager?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is dbrm? When it will be created?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?