Need Help_ My jobs aborted in the middle of loading
Moderators: chulett, rschirm, roy
Need Help_ My jobs aborted in the middle of loading
Hi,
I have an issue with my server job. I have one job that runs every day to load data into target file/table.
Job faild after loading some records in to target, ex..
assume that i have 100 records in my input, job failed after loading 37 records, next time i have to start loading from 38 record.
how would i achinve this using datastage.
Thanks
KR
I have an issue with my server job. I have one job that runs every day to load data into target file/table.
Job faild after loading some records in to target, ex..
assume that i have 100 records in my input, job failed after loading 37 records, next time i have to start loading from 38 record.
how would i achinve this using datastage.
Thanks
KR
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Are you saying that it had happened or you want to prevent such happening?
Unless there is any metadata related information to locate records affected by current load, you cannot restart from failure.
Alternatively you can set the commit size to zero to ensure that it is everything or nothing.
There are other ways to do this but will involve using other objects.
Unless there is any metadata related information to locate records affected by current load, you cannot restart from failure.
Alternatively you can set the commit size to zero to ensure that it is everything or nothing.
There are other ways to do this but will involve using other objects.
Other options are to declare the whole load as one transaction, or to use UPSERT functionality.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
True, we can just suggest general solutions since we don't know the specifics of the 'load' being done here. And the 'skip' solution requires a static source to ensure one run's 38th record is the same as every other run's 38th record.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Thanks
Sainath. since i am not a Premium member i can not view this content.. could you plase give me the answer againSainath.Srinivasan wrote:Craig,
Being Server edition, I did think about deleting or including a constraint to skip 37.
But that is on the assumption that the target is direct load of source with no other dml or "prev-n ...
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom