What does the sqlcode of -818 pertain to?

Answers were Sorted based on User's Feedback



What does the sqlcode of -818 pertain to?..

Answer / srinivasa yadav

MISMATCH OF TIME STAMP TOKEN OF LOAD MODULE AND PLAN.

Is This Answer Correct ?    3 Yes 0 No

What does the sqlcode of -818 pertain to?..

Answer / deepa

Time stamp mismatch.

Is This Answer Correct ?    2 Yes 0 No

What does the sqlcode of -818 pertain to?..

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

Post New Answer

More DB2 Interview Questions

How do I start db2 in windows?

0 Answers  


What is copy pending and check pending in db2?

0 Answers  


Is there any advantage to denormalizing DB2 tables?

1 Answers  


What is concurrency?

0 Answers  


what is the input to PLAN? what is the input to DBRM?

4 Answers  






Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam

1 Answers   Mphasis,


How do you eliminate duplicate values in db2?

0 Answers  


What is a Database Request Module(DBRM)?

4 Answers  


How to create backup table in db2?

0 Answers  


Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

2 Answers  


what is utility for parm lib

0 Answers   IBM,


How is a typical DB2 batch program executed ?

1 Answers  


Categories