Page 1 of 1

SERVER JOB NOT STOPPING!!!!!!

Posted: Thu Jan 24, 2008 2:20 am
by karry450
Hi friends,


I am running a server job,and in the mean time came to know that i didnot include some function in my job.

I tried stopping the job by pressing the stop button, its been more than three hours the job is not getting aborted or stopping.

Is there any alternate to stop/ abort a running server job.


can anyone help me please

thanks

Posted: Thu Jan 24, 2008 2:27 am
by Hemant_Kulkarni
Kill the phantom process in UNIX

Posted: Thu Jan 24, 2008 2:30 am
by karry450
Hemant_Kulkarni wrote:Kill the phantom process in UNIX

I dont have rights to do that.... any other way on datastage director/designer/manager/admin

Posted: Thu Jan 24, 2008 2:33 am
by Hemant_Kulkarni
If you have executed the datastage job from your id, you should be able to log on to unix with the same login id and kill the phantom.

Try to see if you can clean up resources from Datastage Director for that job.

Posted: Thu Jan 24, 2008 2:50 am
by karry450
Hemant_Kulkarni wrote:If you have executed the datastage job from your id, you should be able to log on to unix with the same login id and kill the phantom.

Try to see if you can clean up resources from Datastage Director for that job.
Sorry I am unable to use cleanup resources.

I tried releasing locks but not working

Posted: Thu Jan 24, 2008 7:00 am
by ray.wurlod
Find somebody who does have the requisite authorization, and have them clear the status file for this job.

Re: SERVER JOB NOT STOPPING!!!!!!

Posted: Thu Jan 24, 2008 9:57 am
by dsguy
Go back to designer and recompile the job...should work

Thanks.

Posted: Thu Jan 24, 2008 5:25 pm
by ray.wurlod
If the job is really still running, compilation will be prevented with a "job may be being monitored" message.

Posted: Thu Jan 24, 2008 7:46 pm
by chulett
Specifically, 'cannot get exclusive access to executable' from what I recall. And then it will pony up the 'job may be being monitored' bit. :wink:

Posted: Thu Jan 24, 2008 11:11 pm
by Teej
Shoot the monitor.

...

What?

Re: SERVER JOB NOT STOPPING!!!!!!

Posted: Mon Jan 28, 2008 3:15 pm
by dsserver
I am having the same problem on windows.

Can any one help me how to stop the job.

Thanks in advance.

Posted: Mon Jan 28, 2008 9:42 pm
by ray.wurlod
Aaaarrrgghh!!!

How do they identify which of the potentially many processes this command lists is the right one to kill? And ought they not to check for child processes first? Otherwise they might be creating zombies and rightfully incurring the wrath of their UNIX system administrator.

This is singularly bad advice. The need actually to kill a DataStage process should be extremely rare indeed, and kill -9 should never be used to do so. Use a gentler signal, which affords some grace time to the process.

Posted: Tue Jan 29, 2008 3:54 pm
by jdmiceli
Come on, folks... use your brains :twisted:

If you do not have the permission to do something, then contact someone who does, preferably the person(s) who are responsible for the systems and/or applications related to DataStage. They are trained (hopefully) in the proper methods to stop a DataStage process.

Re: SERVER JOB NOT STOPPING!!!!!!

Posted: Tue Jan 29, 2008 9:14 pm
by ray.wurlod
dsserver wrote:ps -ef....is it not a UNIX command??? How do we do in windows??
Task Manager