Page 1 of 1
Job has been aborted after some rows..?
Posted: Wed Sep 01, 2010 2:35 am
by balaya.ds
I have a datastage job which is having 900 records.
my qst is the job has been aborted after 400 records. i want to start from 401 record ?
how to do that..?
_________________
Posted: Wed Sep 01, 2010 3:00 am
by Sainath.Srinivasan
Delete the first 400 from the source.
Re: Job has been aborted after some rows..?
Posted: Wed Sep 01, 2010 4:25 am
by amit101here
what stages are you using ?
...If you are using sequential file stage..there is property called cleanup on failure..set this as true....and you dont have to worry about this....everytime job is failed, records will be cleaned up...and next run will load from scratch again....
Posted: Wed Sep 01, 2010 6:46 am
by chulett
That's a new one on me.
The next run will always be "from scratch" unless you
specifically code it to be otherwise.
Posted: Wed Sep 01, 2010 8:07 am
by vivekgadwal
If the data volume is what you mentioned here, then I would do an "all or nothing" commit in the database.