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

How to restart Job from abended record?


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Amolondhe007
Warnings : 1

New User


Joined: 16 Apr 2007
Posts: 49
Location: Pune

PostPosted: Fri Nov 06, 2009 1:05 pm
Reply with quote

Q.
If my file contains 100,000 records and job abended at 55,000th records processing then how can i restart job from that record onward by ignoring that record. I can not edit the file as file size is big and it is getting browse substituted?
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Fri Nov 06, 2009 1:28 pm
Reply with quote

The idea of the interview questions forum is for you to supply the answers and for the other forum members to comment upon them.
Back to top
View user's profile Send private message
VVRAVINDRA

New User


Joined: 04 Aug 2008
Posts: 46
Location: Chennai

PostPosted: Fri Dec 04, 2009 11:24 am
Reply with quote

You can use a SORT card, where u can specify
as

SORT FIELDS=COPY,
SKIPREC=<<how many no. of records u want to skip>>
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Fri Dec 04, 2009 2:31 pm
Reply with quote

VVRAVINDRA wrote:
You can use a SORT card, where u can specify
as

SORT FIELDS=COPY,
SKIPREC=<<how many no. of records u want to skip>>
If you do this way, would you call it RESTART?
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Fri Dec 04, 2009 2:37 pm
Reply with quote

And the restart capability of a program or application may require a complete data input rather than a subset. IT all depends on how the program / application has been designed.
Back to top
View user's profile Send private message
VVRAVINDRA

New User


Joined: 04 Aug 2008
Posts: 46
Location: Chennai

PostPosted: Fri Dec 04, 2009 2:43 pm
Reply with quote

Agreed, I went wrong....

I skipped most of it.... my bad.....

well, this can be done in two steps.

First step is the SORT step which is what I mentioned in my previous post...

Second step... use the OUTPUT file of the SORT step in the job which got ABENDED and restart the job, here conditions would apply, first thing we need to check whether the step could be restarted.....
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Fri Dec 04, 2009 2:55 pm
Reply with quote

1. Answer is not appropriate if you are talking about RESTART to start with. And among many other reasons of using RESTART, it is used to avoid manipulation with inputs. If you were always ready to play around with the input to your program why to implement RESTART logic in program at first place?

2. Please read the very first response from Expat again, in this thread.
Back to top
View user's profile Send private message
VVRAVINDRA

New User


Joined: 04 Aug 2008
Posts: 46
Location: Chennai

PostPosted: Fri Dec 04, 2009 3:03 pm
Reply with quote

Quote:

2. Please read the very first response from Expat again, in this thread.


I didn't get this.... is it something that I was not following the forum rules...
If so then I'm extremely sorry icon_sad.gif
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen

PostPosted: Fri Dec 04, 2009 3:03 pm
Reply with quote

My experience was if a record needed to be deleted, approval had to come from a lot of managers even at night if it was a critical application.
Beside that security people were looking over your shoulder to see
what you were doing etc.
Back to top
View user's profile Send private message
VVRAVINDRA

New User


Joined: 04 Aug 2008
Posts: 46
Location: Chennai

PostPosted: Fri Dec 04, 2009 3:09 pm
Reply with quote

Sure I would agree for the fact of getting approvals to strip the bad record... and also the escaltion procedures depending on the SLAs

Lets say if the ABEND happened in a test system then??
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen

PostPosted: Fri Dec 04, 2009 3:18 pm
Reply with quote

Then you still need all the data minus 1 and not minus 55000 if your program is without RESTART logic.
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Fri Dec 04, 2009 3:23 pm
Reply with quote

Quote:
Q.
If my file contains 100,000 records and job abended at 55,000th records processing then how can i restart job from that record onward by ignoring that record. I can not edit the file as file size is big and it is getting browse substituted?


Have one row in control table, may be with
key= JOBNAME
restart_flag=N
start_rec=1
and some other details if necessary

if JOB abends then support can make restart_flag=Y and start_rec=(abended rec +1) in control table before the RESTART the job.

In your program check if restart_flag in control table is N then process normally
If RESTART=Y then check for start_rec value. skip those records and enter in processing loop.
at successful completion of program change restart_flag to 'Y'
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Fri Dec 04, 2009 3:26 pm
Reply with quote

VVRAVINDRA wrote:
I didn't get this.... is it something that I was not following the forum rules...
If so then I'm extremely sorry icon_sad.gif
No need to be this sorry, suggestion from expat is to encourage original posters to start with their answer(s), their answers in their own words before we can suggest whether that(those) was/were correct or wrong and why?
Back to top
View user's profile Send private message
VVRAVINDRA

New User


Joined: 04 Aug 2008
Posts: 46
Location: Chennai

PostPosted: Fri Dec 04, 2009 3:26 pm
Reply with quote

Quote:

Then you still need all the data minus 1 and not minus 55000 if your program is without RESTART logic.

That was my intention but what if u get all the necessary emergency access to the dataset and you know the bad record and bad data, u corrected it and then u want to apply your restart techniques...
Back to top
View user's profile Send private message
karisurya

New User


Joined: 02 Aug 2007
Posts: 64
Location: Bangalore

PostPosted: Fri Dec 04, 2009 5:32 pm
Reply with quote

I agree with Sambhaji and it works only if you have that restart logic in application. My best guess is the interviewer might be checking how familar are you with restart logic as said at the application level.
If he asks ways to solve that problem then i think Ravindra's approach is one of the apprach.
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 -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 8
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts FINDREP - Only first record from give... DFSORT/ICETOOL 3
No new posts To find whether record count are true... DFSORT/ICETOOL 6
No new posts Reorg abended with REASON=X'00E40347' DB2 2
Search our Forums:

Back to Top