Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Restart Logic

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Restart Logic
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

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Fri Feb 27, 2015 9:38 pm    Post subject:
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    Post subject:
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

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Sat Feb 28, 2015 3:04 am    Post subject:
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: 1219
Location: Israel

PostPosted: Mon Mar 02, 2015 7:58 pm    Post subject:
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    Post subject: Reply to: Restart Logic
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Wildcard logic in COBOL dudenithy COBOL Programming 13 Thu Sep 01, 2016 7:36 pm
No new posts Sort Logic to extract data scorp_rahul23 DFSORT/ICETOOL 13 Tue Mar 01, 2016 1:22 am
No new posts Need a logic to validate the data in ... sandeep kumar302 COBOL Programming 17 Mon Feb 01, 2016 3:30 pm
No new posts Tricky sort logic required pgopi92 DFSORT/ICETOOL 3 Mon Jan 25, 2016 3:29 pm
No new posts DB2 - CURRENT DATE + 2 YRS logic balaji81_k DB2 3 Thu Nov 26, 2015 3:07 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us