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 |
what is SMP/E? and what are the major steps of it? thanks...
What is ibm db2 database?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
What is scrollable cursor in db2?
How we create a tables in db2,what is the process/syntax to create a table with example plz?
Compare a subselect to a join?
How does coalesce work?
Can we use select * statement in cobol program without giving field names ???
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
Which command is used to remove all rows from a table?
Give a brief description of db2 isolation levels?