REBIND-TIMESTAMP

raghav08 · New User Joined: 03 Jun 2008 Posts: 94 Location: Bangalore

Hello.

If I rebind the plan, do I get timestamp error while executing COBOL-DB2 program?

Thanks.

agkshirsagar · Posted: Thu Sep 03, 2009 8:31 pm

Let me first put my understanding of what your question really is-

You havent compiled the program and you did a REBIND and then is it possible to get a timestamp mismatch error?
By timestamp error, I understand you are referring to -818 and -805 SQLCODEs in general. Right

Answer is NO you won't receive error, because, REBIND just reestablishes the access path and uses the consistency token from the DB2 catalog tables, not the system time when you did a rebind.