Job aborted after 500 rows?

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Nagac
Premium Member
Premium Member
Posts: 127
Joined: Tue Mar 29, 2011 11:39 am
Location: India

Job aborted after 500 rows?

Post by Nagac »

Hi All

I have a job like below

Dataset---->Transformer---->DB2

When i run the job it's got aborted after 500 rows .(total rows were 2000)

Is it possible to start from 501 row??
antonyraj.deva
Premium Member
Premium Member
Posts: 138
Joined: Wed Jul 16, 2008 9:51 pm
Location: Kolkata

Post by antonyraj.deva »

If you have checkpoint option enabled at the project level, then Yes.
TONY
ETL Manager
Infotrellis India

"Do what you can, with what you have, from where you are and to the best of your abilities."
SURA
Premium Member
Premium Member
Posts: 1229
Joined: Sat Jul 14, 2007 5:16 am
Location: Sydney

Re: Job aborted after 500 rows?

Post by SURA »

Nagac wrote:Hi All

I have a job like below

Dataset---->Transformer---->DB2

When i run the job it's got aborted after 500 rows .(total rows were 2000)

Is it possible to start from 501 row??

What error captured in director?
Ravi.K
Participant
Posts: 209
Joined: Sat Nov 20, 2010 11:33 pm
Location: Bangalore

Post by Ravi.K »

Check at transfer level option enabled like "abort after 500 rows"
Cheers
Ravi K
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

They're not asking why it aborted, but rather how to get it to pick up from where it left off when it is restarted. Unfortunately, checkpoints have nothing to do with this, that only affects Sequence jobs and job activites there.

And the answer is - only if you code it in.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply