IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

db2-how can i rectify timp stamp error if it occurs


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
tilak.arani
Currently Banned

New User


Joined: 07 Sep 2006
Posts: 2
Location: chennai

PostPosted: Thu Sep 07, 2006 7:13 pm
Reply with quote

how can i rectify timp stamp error if it occurs

i want answer other than REBIND
Back to top
View user's profile Send private message
raghunathns

Active User


Joined: 08 Dec 2005
Posts: 127
Location: rochester

PostPosted: Thu Sep 07, 2006 9:14 pm
Reply with quote

check you steplib where is ur load module. you may be accessing the old load module at different location.
Back to top
View user's profile Send private message
anadhamohan

New User


Joined: 27 Sep 2005
Posts: 25
Location: india

PostPosted: Fri Sep 08, 2006 2:39 pm
Reply with quote

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
View user's profile Send private message
stly
Warnings : 1

New User


Joined: 25 Jul 2005
Posts: 93

PostPosted: Fri Sep 08, 2006 3:46 pm
Reply with quote

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
View user's profile Send private message
raghunathns

Active User


Joined: 08 Dec 2005
Posts: 127
Location: rochester

PostPosted: Fri Sep 08, 2006 7:08 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Error when install DB2 DB2 2
No new posts CLIST - Virtual storage allocation error CLIST & REXX 5
No new posts Error while running web tool kit REXX... CLIST & REXX 5
No new posts Getting Error while trying to establi... DB2 3
Search our Forums:

Back to Top