Hi All,
Can anyone please guide me how to restart the job incase if the job fails .
for example i have 2million records to be loaded into the table.
i have input a seqential file or the dataset needs to be loaded into sybase database.
i want to just use insert commmand by deleting the perious records.
While loading 2milllion records if the job fails at 10000 records then how to handle in such senario.
I checked in forum it tells about hash file or caputure the record.
but how exactly i need to work on,as i am new to datastage not able to get the required results..
please guide..
job fails while loading into target table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Whatever you want to do in terms of restarting from a point of failure you must design. And that involves keeping track of, or discovering subsequently, which rows were successfully committed to the database.
The only automatic restart in DataStage is from the start of the job that failed. You must design any cleanup that has to occur before that, should you wish to take this route.
The only automatic restart in DataStage is from the start of the job that failed. You must design any cleanup that has to occur before that, should you wish to take this route.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Thanks ray,ray.wurlod wrote:Please delete your duplicate post before anyone responds to it
Can you please guide me if my understanding is wrong.
I thought i will store the output in the file and then do the look up with the same file again and then insert into the fnal table.
So which ever matches i wont insert and insert the remaing records into the table.
Is this the correct way to do ...
Or shal i re-run the job in sequencer, but again to achieve this i need your help.
Please suggest...