Interested to Buy Any Domain ? << Click Here >> for more details...
How to solved 818 error
- 4 Answers
- 14743 Views
- Keane India Ltd, Wipro, I also Faced
- E-Mail Answers
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 innodb buffer pool?
What is the maximum length of sqlca?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?
What is a cursor and what is its function?
What is the use of db2?
What does the sqlcode of -818 pertain to?
How many sub queries can you combine together ?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What happens in bind step in a db2 program?
What is a clustered index?
COBOL 
