Page 1 of 1
Posted: Mon Jan 19, 2009 8:54 am
by samsuf2002
Try killing the job from command line.
Posted: Mon Jan 19, 2009 9:24 am
by samsuf2002
I would suggest you to try releasing the job from DS administrator if you are not able to do it from DS director. Go to DS Administrator, select the project, click on command button, give command LIST.READU ALL, look for the user and inode for that particular locked process, give command UNLOCK USER <user number> ALL , or UNLOCK <inode number> ALL.
Killing the job from command line is the option in worst case and you should make sure the process you are killing can effect other process or not. The way to kill from unix is kill -9 <processid>
Please try to compile the job
Posted: Mon Jan 19, 2009 10:49 am
by dinakaran_s
There is a possibility, server crash while the job still is running. If this happens then, job will be shown running in the director.
Please try to compile the jobs otherwise restart the DataStage service and try compile the job.
Posted: Mon Jan 19, 2009 12:44 pm
by crouse
This works in 7.x, should work in 8.x...
Have you tried this specifically in Director?
Highlight the job, click Job -> Clear Status File - Yes
Should remove the running status. Should only be used as your last option.
Re: Job in state running
Posted: Mon Jan 19, 2009 1:08 pm
by chulett
RAI ROUSES wrote:Did the clear status of the job, in the log it appears the message that is done the clear to the RT FILE, but the job continues in the state "running".
Odd, another 8.x quirk it seems.
Posted: Mon Jan 19, 2009 1:20 pm
by crouse
I couldn't quite determine if the poster indicates the LOG is cleared (since RT_LOG is mentioned) or the STATUS cleared. I was assuming the log was cleared and that CLEAR STATUS FILE hadn't been done (yet).
Posted: Mon Jan 19, 2009 1:24 pm
by chulett
True, it is a little ambiguous, but I was going by the "Did the clear status of the job" part. Guess we need to wait and see.
Posted: Mon Jan 19, 2009 4:19 pm
by ray.wurlod
Did you refresh the Director's view after clearing the status file?
Posted: Mon Jan 19, 2009 8:02 pm
by kandyshandy
If this is not a big deal, restart services (nodeagent/DS/Websphere).
Posted: Tue Jan 20, 2009 12:45 pm
by RAI ROUSES
We restart the services of DataStage, the Job remained with the state "running", we have done the "Clear Status File" and compile the Job. We run Have you made the run of Job, which last 10 minutes ended with success: D
But today we have the same situation, another Job with running status, but dont do nothinng , the same situation, when we restart the services of DataStage, it also released this Job.
Some idea what caused this problem ?