CHECKPOINT concept

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
chandra
Participant
Posts: 88
Joined: Sun Apr 02, 2006 6:50 pm
Location: India

CHECKPOINT concept

Post by chandra »

Suppose i hv developed a JOB which consists of 5 compontents , after executing 3 components the job fails , when next time i start a job it should start from component 3.
how to do that ( i compared the concept with ab initio checkpoint)..


tnxs in adv
[/b]
chandra ,
Hyd
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

Why do the last 3 posts from you in the space of 5 minutes look like job interview questions?
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Do you mean Job or Job Sequence ?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chandra
Participant
Posts: 88
Joined: Sun Apr 02, 2006 6:50 pm
Location: India

Post by chandra »

jod sequencer is not my point
chandra ,
Hyd
chandra
Participant
Posts: 88
Joined: Sun Apr 02, 2006 6:50 pm
Location: India

Post by chandra »

By specifying Checkpointing in job sequence properties, if we restart the job. Then job will start by skipping upto the failed record.this option is available in 7.5 edition...
i want ti know is the option avalible in JOB.
chandra ,
Hyd
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

chandra wrote:By specifying Checkpointing in job sequence properties, if we restart the job. Then job will start by skipping upto the failed record.this option is available in 7.5 edition...
Um... no. If you restart the sequence it will 'skip up to' the failed job and restart the sequence from failed job.
chandra also wrote:i want ti know is the option avalible in JOB.
No, not as an option. That doesn't mean you can't code it in yourself, however.
-craig

"You can never have too many knives" -- Logan Nine Fingers
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

If your job has an open cursor with a selection set using a rollback segment and the job fails, the process ends, and the rollback+selection set are released, how could you possible re-enter processing exactly where you aborted when the selection set in the rollback has been released?

You program in your restartability in the way you architect your ETL application.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

chandra wrote:jod sequencer is not my point
Neither server nor parallel jobs have checkpointing capability, unless you design it in yourself.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply