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 is a thread?
What information is held in SYSIBM.SYSCOPY?
What is normalization and what are the five normal forms?
What is a collection in db2?
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
What is the format (internal layout) of ?TIMESTAMP??
what is a collection?
Q3. How will you fetch duplicate values from a DB2 table?
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....
What action db2 takes when a program aborts in the middle of a transaction?
How to resolve -504 sql code in DB2?