SERVER JOB NOT STOPPING!!!!!!

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
karry450
Participant
Posts: 201
Joined: Wed Nov 14, 2007 11:31 pm
Location: HYD

SERVER JOB NOT STOPPING!!!!!!

Post 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
Hemant_Kulkarni
Premium Member
Premium Member
Posts: 50
Joined: Tue Jan 02, 2007 1:40 am

Post by Hemant_Kulkarni »

Kill the phantom process in UNIX
karry450
Participant
Posts: 201
Joined: Wed Nov 14, 2007 11:31 pm
Location: HYD

Post 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
Hemant_Kulkarni
Premium Member
Premium Member
Posts: 50
Joined: Tue Jan 02, 2007 1:40 am

Post 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.
karry450
Participant
Posts: 201
Joined: Wed Nov 14, 2007 11:31 pm
Location: HYD

Post 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
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Find somebody who does have the requisite authorization, and have them clear the status file for this job.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
dsguy
Participant
Posts: 34
Joined: Thu Mar 09, 2006 10:37 am

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

Post by dsguy »

Go back to designer and recompile the job...should work

Thanks.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

If the job is really still running, compilation will be prevented with a "job may be being monitored" message.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Teej
Participant
Posts: 677
Joined: Fri Aug 08, 2003 9:26 am
Location: USA

Post by Teej »

Shoot the monitor.

...

What?
dsserver
Participant
Posts: 4
Joined: Mon Jan 28, 2008 9:47 am

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

Post by dsserver »

I am having the same problem on windows.

Can any one help me how to stop the job.

Thanks in advance.
Thanks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
jdmiceli
Premium Member
Premium Member
Posts: 309
Joined: Wed Feb 22, 2006 10:03 am
Location: Urbandale, IA

Post 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.
Bestest!

John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services


"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

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

Post by ray.wurlod »

dsserver wrote:ps -ef....is it not a UNIX command??? How do we do in windows??
Task Manager
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