|
View previous topic :: View next topic
|
| Author |
Message |
Amolondhe007
Warnings : 1
New User
Joined: 16 Apr 2007
Posts: 49
Location: Pune
|
|
|
|
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 |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8796
Location: Welsh Wales
|
|
|
|
| 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 |
|
|
VVRAVINDRA
New User
Joined: 04 Aug 2008
Posts: 46
Location: Chennai
|
|
|
|
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India
|
|
|
|
| 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 |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8796
Location: Welsh Wales
|
|
|
|
| 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 |
|
|
VVRAVINDRA
New User
Joined: 04 Aug 2008
Posts: 46
Location: Chennai
|
|
|
|
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India
|
|
|
|
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 |
|
|
VVRAVINDRA
New User
Joined: 04 Aug 2008
Posts: 46
Location: Chennai
|
|
|
|
| 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  |
|
| Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
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 |
|
|
VVRAVINDRA
New User
Joined: 04 Aug 2008
Posts: 46
Location: Chennai
|
|
|
|
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 |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
| Then you still need all the data minus 1 and not minus 55000 if your program is without RESTART logic. |
|
| Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA
|
|
|
|
| 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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India
|
|
|
|
| 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 |
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 |
|
|
VVRAVINDRA
New User
Joined: 04 Aug 2008
Posts: 46
Location: Chennai
|
|
|
|
| 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 |
|
|
karisurya
New User
Joined: 02 Aug 2007
Posts: 64
Location: Bangalore
|
|
|
|
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 |
|
|
|
|
