View previous topic :: View next topic
|
Author |
Message |
tilak.arani Currently Banned New User
Joined: 07 Sep 2006 Posts: 2 Location: chennai
|
|
|
|
how can i rectify timp stamp error if it occurs
i want answer other than REBIND |
|
Back to top |
|
|
raghunathns
Active User
Joined: 08 Dec 2005 Posts: 127 Location: rochester
|
|
|
|
check you steplib where is ur load module. you may be accessing the old load module at different location. |
|
Back to top |
|
|
anadhamohan
New User
Joined: 27 Sep 2005 Posts: 25 Location: india
|
|
|
|
Timestamp mismatch can be overruled by Pre-Compile/Compile/Link-Edit and then Rebind Package/Plan and try running the job. This is the only solution which can be taken to avoid -818 SQLCODE.
Thank you,
Aravindakshan A |
|
Back to top |
|
|
stly Warnings : 1 New User
Joined: 25 Jul 2005 Posts: 93
|
|
|
|
anadhamohan wrote: |
Timestamp mismatch can be overruled by Pre-Compile/Compile/Link-Edit and then Rebind Package/Plan and try running the job. This is the only solution which can be taken to avoid -818 SQLCODE.
Thank you,
Aravindakshan A |
yes i too agree with aravind . |
|
Back to top |
|
|
raghunathns
Active User
Joined: 08 Dec 2005 Posts: 127 Location: rochester
|
|
|
|
you are running the program after successful compilation. so you have valid plan and load module. if you compile again also same thing. what is the differece.
you have to check the db2 subsystem and load module location in your run jcl. |
|
Back to top |
|
|
|