Job Reset and Log Reset

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
kaps
Participant
Posts: 452
Joined: Tue May 10, 2005 12:36 pm

Job Reset and Log Reset

Post by kaps »

Can someone tell me what actually happens when we reset the DataStage job ? Does it only erase the check point information in seqence jobs or does it do anything more ?

what happens when we do log reset ? I see a event type called DSJ.LOGRESET. Is there any similar command to run from command line ?

Thanks
dwandbi
Participant
Posts: 29
Joined: Sat Feb 04, 2006 6:17 pm

Job Reset

Post by dwandbi »

Resetting a job from either finihed state or from aborted state brings back the job in a stage to be able to recompile the job. Hence by resetting the job, we are able to bring back the job in a runnable state.

thanks,
Tom
gateleys
Premium Member
Premium Member
Posts: 992
Joined: Mon Aug 08, 2005 5:08 pm
Location: USA

Re: Job Reset

Post by gateleys »

dwandbi wrote:Resetting .........brings back the job in a stage to be able to recompile the job.
Hi dwandbi,
The first part of your answer implies that when a job is reset, it gets to a "ready to be recompiled" state. Meaning, one should recompile the job to run it again.
dwandbi wrote:Hence by resetting the job, we are able to bring back the job in a runnable state.
The latter part seems to imply that when the job is reset, it goes into a runnable state. Meaning the job does NOT need to be recompiled in order to run again.
Can you clarify?

Thanks,
gateleys
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Both statements are correct. Resetting a job puts it back to a runnable state, no recompile needed. Aborted jobs must be reset before they can be recompiled.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Stopped jobs also must be reset before they can be re-run.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Re: Job Reset

Post by kumar_s »

dwandbi wrote:Resetting a job from either finihed state or from aborted state brings back the job in a stage to be able to recompile the job. Hence by resetting the job, we are able to bring back the job in a runnable state.

thanks,
Tom
Compilation does not require the job to be in runnable state. Unless the job is running, it can be compiled at any state.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

DSJ.LOGRESET is a constant for selecting log events of type "job has been reset" using DSGetNewestLogId(). It is not a command.
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