job status

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
przytula
Participant
Posts: 27
Joined: Wed Apr 14, 2004 1:31 am
Location: Brussels Belgium
Contact:

job status

Post by przytula »

we missed an instruction in a routine and the job keeps running
we tried to stop the job : status = running
we did shutdown of engine and restarted the engine = status running
we tried as in other topic
COPY FROM RT_LOGnnn TO VOCLIB '//PURGE.SETTINGS' OVERWRITING
CLEAR.FILE RT_LOGnnn
COPY FROM VOCLIB TO RT_LOGnnn '//PURGE.SETTINGS' DELETING
with 162 as jobnbr (found from admin select)
same result
Is there any way to stop/abort a job in a clean way ?
Thanks for all help
Best Regards, Guy Przytula
Best Regards, Guy Przytula
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The job is stopped.

But it never got a chance to update its records in the RT_STATUSnnn table.

Probably quickest is to Clear Status File from Director.

Otherwise, you must reset the status value for job, resource and active stage records in RT_STATUSnnn, to explain which would take more time than I have right now.

Your clearing of the RT_LOGnnn table would have no effect, as you reported. Well done for thinking to preserve the purge settings, however.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
przytula
Participant
Posts: 27
Joined: Wed Apr 14, 2004 1:31 am
Location: Brussels Belgium
Contact:

status

Post by przytula »

thanks for the update/info
In director : job : stop is active but reset is gray = not selectable
we tried stop = server was informed, but did not change the status.
Any other way to reset the status (maybe on engine machine ?)
Thanks and Best Regards, Guy Przytula
Best Regards, Guy Przytula
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

The ONLY method you should use to stop a job in an emergency is the unix kill command. You are lucky you didn't corrupt your DS project with the things you did. NEVER attempt those things unless you absolutely understand the internals. You are lucky you didn't really screw things up.

To stop a job, do a "ps -ef |grep phantom" and look for your job. THE DSD.RUN is the parent process, the DSD.StageRun are the active stages. Issue a kill processid for one of the Stage run phantoms. Usually killing one of them is sufficient to make the whole job abort. But, you can kill them all including the DSD.RUN phantom. Since nothing's left to update the jobs status file, you can now simply recompile the job, clear the status using the Director, whatever. You can't RESET because the job still indicates running so the Director doesn't allow you.
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
Post Reply