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 |
wht is d/f between union and joins ?
Name the different types of Table spaces.
What are the advantages of using a PACKAGE?
When Can you be sure that a query will return only one row?
What's the difference between DB2 active log and archive log? Thanks a lot...
When DB2 connection fails, will online program work or give errors.
What is null indicator in cobol db2?
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
What is cascading rollback?
Define db2 and its databases?
Explain about rct in db2?
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?