How to solved 818 error
Answers were Sorted based on User's Feedback
Answer / nimsatprasad
>> -818 time stamp mismatch.
>> This is generated when the consistency tokens in the
DBRM and the load module are different.
>> So rebind the Cobol+Db2 program then successfully we run
the program.
| Is This Answer Correct ? | 15 Yes | 3 No |
Answer / steve
Check that the DBRMLIB being used in the bind has a time
stamp for the abending program that matches the LOADLIB.
Sometimes all we need to do is point to the correct
libraries. If that does not work then a rebind or
precompile, compile, relink and then rebind will work. The
last option always works, but many times an interviewer
wants to know if we understand what causes an -818. If we
just say we would recompile, link and bind we do not
demonstrate understanding of the root cause.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / as
I guess rebinding wont help in this scenario (because
rebind doesnt genearate new consistency tokens). We need to
pre-compile and compile the program again.
| Is This Answer Correct ? | 6 Yes | 4 No |
Answer / guest
-818 is a plan with matching contoken is missing. A bind of
the required DBRM/package to a plan will solve the problem.
| Is This Answer Correct ? | 2 Yes | 1 No |
What does the REORG Utility do?
What is a page in db2?
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
What is a DBRM, PLAN ?
Can we able to find all the Table names under a Particular Plan?
What is the difference between drop table and delete table?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
What is the picture clause of the null indicator variable?
why we go for SPUFI for creating tables or for sql queries?
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
List out the buffer pools in db2