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

Restart Logic


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
suraaj

New User


Joined: 16 Apr 2009
Posts: 69
Location: Canada

PostPosted: Fri Feb 27, 2015 8:47 pm
Reply with quote

A job processed 4 VSAM records and 4 DB2 row without performing a COMMIT. The job ABENDed on the 5th processing record. Explain how we could handle a restart for this situation.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2567
Location: NYC,USA

PostPosted: Fri Feb 27, 2015 9:38 pm
Reply with quote

It depents on your Commit frequency. If you are doing it let us say after 10 records then after you commit store the last record into Restart table. Now if 11th record is a bad one and Job abends then when you Restart it have a dummy read till last key that is stored and then process further. Now with your numbers above it won't commit so you need to process from top.
Back to top
View user's profile Send private message
suraaj

New User


Joined: 16 Apr 2009
Posts: 69
Location: Canada

PostPosted: Fri Feb 27, 2015 10:08 pm
Reply with quote

There is no commit. The job has already run. Now we have to handle this.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2567
Location: NYC,USA

PostPosted: Sat Feb 28, 2015 3:04 am
Reply with quote

Either correct the bad record or remove it and then restart and then investigate further with that record as to what and why happened as you do not want to compromise your SLA.
Back to top
View user's profile Send private message
Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1348
Location: Israel

PostPosted: Mon Mar 02, 2015 7:58 pm
Reply with quote

Is the VSAM file updated also, or only the DB2 table ?

As the job has abended and you had no commits, all DB2 updates have been rollbacked. You only need to correct the error (the data or the program) and rerun the job.

If you had had commits before the abend, it would be more difficult to resume the process (because you'd need to skip an unknown number of updates).
Back to top
View user's profile Send private message
suraaj

New User


Joined: 16 Apr 2009
Posts: 69
Location: Canada

PostPosted: Tue Mar 03, 2015 7:45 am
Reply with quote

Yes both VSAM and DB2 table have been updated.
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 IMS Restart Failure IMS DB/DC 3
No new posts Sync logic between VSAM files and DB2... COBOL Programming 9
No new posts Restart logic by using cursor name in... DB2 1
No new posts Do we need to restart DB2 Z/OS for DA... DB2 0
This topic is locked: you cannot edit posts or make replies. Compare two files logic in COBOL COBOL Programming 4
Search our Forums:

Back to Top