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 |
Is there any advantage to denormalizing DB2 tables?
What is sqlcode -922 ?
What is SPUFI?
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?
How do you retrieve the first 5 characters of firstname column of db2 table emp?
What is sqlca’s maximum length?
how to take the back up of the DB2 table.
What are the contents of a dclmgen?
What is ACQUIRE/RELEASE in BIND?
What is an asychronous write?
What is the difference between static and dynamic SQL?
Explain in detail about buffer manager and its functionalities?