What does the sqlcode of -818 pertain to?
Answers were Sorted based on User's Feedback
Answer / srinivasa yadav
MISMATCH OF TIME STAMP TOKEN OF LOAD MODULE AND PLAN.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / s
When the application goes through precompile, compile and
link-edit phase and the bind plan is not done. Because when
you precompile a pgm, a new consistency token is placed in
modified source code and the DBRM but if you dont bind the
plan, the dbrm/package with that consistency token will not
be found. Hence the error message -818.
| Is This Answer Correct ? | 1 Yes | 3 No |
What are db2 tables?
What is meant by a unit of recovery?
what is SMP/E? and what are the major steps of it? thanks...
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
On which levels locks can be applied?
What is a plan and package in db2?
What is catalog database in db2?
What is the difference between cursor and select statement?
Is there any advantage to denormalizing DB2 tables?
what are extents?
What is read-only cursor?
How to find the number of rows in db2 tables?