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

How to see the structure of db2 table??

4 Answers   IBM,


What is null value in db2?

1 Answers  


What is the difference between drop table and delete table?

1 Answers  


what is datacom db?

2 Answers   CSC,


What is a lock?

1 Answers  


What is concurrency?

1 Answers  


what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........

1 Answers  


which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit

2 Answers   Accenture, Wipro,


Define declaration generator (dclgen).

1 Answers  


how to execute qcmdexc in rpgle?plz write code also?

1 Answers   IBM,


how to resolve -805. give clear explination for that

2 Answers   IBM,


How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)

2 Answers  


Categories