Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 1827
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: 1827
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: 1252
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 Is CICS BMS logic on z/OS different ... Andi1982 CICS 2 Fri Dec 01, 2017 1:56 pm
No new posts Control-M restart instruction sonaliingle CA Products 2 Tue Nov 28, 2017 5:05 pm
No new posts Restart=Step not working ALAK SAHA JCL & VSAM 6 Fri Jun 30, 2017 6:28 pm
No new posts Need help in building a logic Benchwarmer All Other Mainframe Topics 4 Wed Feb 22, 2017 2:49 am
No new posts Wildcard logic in COBOL dudenithy COBOL Programming 13 Thu Sep 01, 2016 7:36 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us