-818 error due to timestamp mismach

nandini · New User Joined: 27 Feb 2004 Posts: 18

Hi

I have a doubt in db2.the error -818 is due to timestamp mismach.In which condition this will occur.When will it come. Dont say refer to manuals pls.

nandini

priya · Posted: Sun Jun 06, 2004 9:57 am

Time Stamp error , because the time stamp value in your PLAN/PACKAGE and in your program doesn't match.

nandini · New User Joined: 27 Feb 2004 Posts: 18

Hi priya,

In which case the mismatch will occur.
Suppose if we are changing the source progm and not binding again,whether it will occur mismatch.What are the other conditions.

Love
Nandini

anuradha · Posted: Tue Jun 08, 2004 8:58 pm

This problem can occur if you:

1. Precompile, compile, and link, without doing a BIND of the
application,
2. Precompile and BIND, without doing the compile and link for the
application program, or
3. BIND the application using a DBRM that resulted from a different
precompile of the application program than that which produced the
object module that is linked into the application module.

Hope this helps you nandini.

Thanks,
Anu

Venku · Posted: Wed Jun 09, 2004 12:00 pm

When you are executing a CICS transaction that connects to DB2, You need to refresh the load module using CEMT S PROG (Program Name) NEW whenever a new load module is created. We can still get -818 error when a new load module and a new plan is created but forgot to make a new copy in CICS. Unless we create a new copy, CICS still points to the older version of the load. Bestwishes