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 a thread?

3 Answers  


What information is held in SYSIBM.SYSCOPY?

1 Answers  


What is normalization and what are the five normal forms?

1 Answers  


What is a collection in db2?

0 Answers  


how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?

1 Answers   Hewitt,


Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 Answers  


What is the format (internal layout) of ?TIMESTAMP??

1 Answers  


what is a collection?

2 Answers  


Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,


in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....

4 Answers   Infosys,


What action db2 takes when a program aborts in the middle of a transaction?

0 Answers  


How to resolve -504 sql code in DB2?

2 Answers   Cap Gemini,


Categories