How to solved 818 error

Answers were Sorted based on User's Feedback



How to solved 818 error..

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

How to solved 818 error..

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

How to solved 818 error..

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

How to solved 818 error..

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

Post New Answer

More DB2 Interview Questions

what is difference between Static call and Dynamic call? How does it function?

1 Answers   Syntel,


Can one database have multiple instances?

0 Answers  


What can the Locate option of the Repair Utility accomplish?

2 Answers  


What is precompiler in db2?

0 Answers  


How to find the maximum value in a column in the db2 database?

0 Answers  






What is sqlca’s maximum length?

0 Answers  


What is a bind card?

0 Answers  


What is dpf in db2?

0 Answers  


What is nvl in db2?

0 Answers  


What is null in db2?

0 Answers  


is it compulsory commitment control in journal?

0 Answers   TCS,


can i code union in cobol-db2 pgm ?

4 Answers   Patni,


Categories