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 |
wht are the restrictions for union ?
How many buffer pools are there in DB2?
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
Is DECLARE TABLE in DCLGEN necessary? Why it used?
For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
how to execute qcmdexc in rpgle?plz write code also?
How does DB2 determine what lock-size to use?
why we create view.
What is the use of commit in db2?
What is a DB2 plan?
What are the various locking levels available?