Job in state running

samsuf2002 · Post by **samsuf2002** » Mon Jan 19, 2009 8:54 am

Try killing the job from command line.

samsuf2002 · Post by **samsuf2002** » Mon Jan 19, 2009 9:24 am

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>

dinakaran_s · Post by **dinakaran_s** » Mon Jan 19, 2009 10:49 am

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.

crouse · Post by **crouse** » Mon Jan 19, 2009 12:44 pm

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.

chulett · Post by **chulett** » Mon Jan 19, 2009 1:08 pm

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.

crouse · Post by **crouse** » Mon Jan 19, 2009 1:20 pm

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).

chulett · Post by **chulett** » Mon Jan 19, 2009 1:24 pm

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.

ray.wurlod · Post by **ray.wurlod** » Mon Jan 19, 2009 4:19 pm

Did you refresh the Director's view after clearing the status file?

kandyshandy · Post by **kandyshandy** » Mon Jan 19, 2009 8:02 pm

If this is not a big deal, restart services (nodeagent/DS/Websphere).

RAI ROUSES · Post by **RAI ROUSES** » Tue Jan 20, 2009 12:45 pm

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 ?

DSXchange

Job in state running

Please try to compile the job

Re: Job in state running