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.

Define data page.

0 Answers  

---

What is alias in db2?

0 Answers  

---

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

2 Answers   Accenture, Wipro,

---

Explain the use of the WHERE clause?

1 Answers  

---

How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

6 Answers   Wipro,

---

What is an instance database?

0 Answers  

---

What is the maximum length of sqlca?

0 Answers  

---

Explain package in db2 and its advantages?

0 Answers  

---

What is a LIKE table and how is it created?

2 Answers  

---

Which is faster delete or truncate?

0 Answers  

---

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

0 Answers  

---

Return code 100 means?

6 Answers   Cap Gemini,

---