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.

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.

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.

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.

What is a Database Request Module(DBRM)?

4 Answers  

---

What is a root page?

1 Answers  

---

What is the self-referencing constraint?

2 Answers  

---

What is the command used by TSO users to invoke DB2?

2 Answers   IBM,

---

How can the duplicate values be eliminated from db2 select?

0 Answers  

---

what is the use of commit ? and what is the syntax?

2 Answers   Deloitte,

---

My sql statement select avg(salary) from emp yields inaccurate results. Why?

0 Answers  

---

What is -904 sql code? How to resolve it?

3 Answers  

---

What will the FREE command do to a plan?

2 Answers  

---

How can you display the current date & current time ?

7 Answers   Cap Gemini,

---

What is the difference between oracle and db2?

0 Answers  

---

Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

2 Answers   Verizon,

---