Job Process killing

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
sasidhar_kari
Premium Member
Premium Member
Posts: 62
Joined: Wed Dec 08, 2004 2:26 am

Job Process killing

Post by sasidhar_kari »

Hi All,

While i m working on jobs suddenly connection got broken and by the time i have opened some jobs in designer. I have tryed to kill the processes using cleanup resources option in Director(By selecting the process id and clicked on logout button) , but i m unable to kill the processes.Process id's are still exsting and im unable to open the Jobs which are opened when connection got broken.

Can any one help me telling any other way to kill the proccesses.

Thanks in Advance,
yaminids
Premium Member
Premium Member
Posts: 387
Joined: Mon Oct 18, 2004 1:04 pm

Re: Job Process killing

Post by yaminids »

Sasidhar,

It means that you have some 'Phantom' jobs. If the DataStage server is on Unix then the only way to get back the jobs is to restart the server.

Hope this helps
Yamini
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

A Server restart is not always necessary, but it is the simplest method. Just remember that when killing UNIX processes never use a kill -9. If this happens to you often, please activate the deadlock daemon in DataStage and that way it will remove stale locks for you.
sasidhar_kari
Premium Member
Premium Member
Posts: 62
Joined: Wed Dec 08, 2004 2:26 am

Post by sasidhar_kari »

Hi,
Can u please tell me how to activate the Dead lock daemon in datastage

Thanks U
Sasi
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

More information on the deadlock daemon and it's use are found in the documentation, but this is the cut-and-paste from the installation guide:
Deadlock Daemon - Windows and UNIX
The default state of the daemon is OFF. You must change this to ON in
order to use the daemon. To do this, you must change the value of the
start variable in the dslockd.config file in the DataStage server
directory.
sasidhar_kari
Premium Member
Premium Member
Posts: 62
Joined: Wed Dec 08, 2004 2:26 am

Post by sasidhar_kari »

Hi Arnd,
Thank U
Madhav_M
Participant
Posts: 43
Joined: Sat Jul 10, 2004 5:47 am

Post by Madhav_M »

You can also follow the following process if u hv access to DS Administrator

Using DS administrator.
select project wherein the job is locked
select COMMAND button
type DS.TOOLS
select 5 (Administrative tasks)
select 4 (list all locks)
you might need to resize the window to view all the data
write down the PID of the job that is locked
once all have been listed you will return to the main menu

select 7 (clear locks held by process)
type the PID of the job that is locked
confirm with 'Y'
Post Reply