How to abort a job from back end process

suresh.narasimha · Post by **suresh.narasimha** » Sun Jul 27, 2008 6:02 pm

Hi Everyone

Goodmorning

I have a source(seq file), a transformer and 2 targets one seq file and the other as OCI.

I have constraints to my targets, so zero records are being written into my seq file and rest all records are routed to OCI ( about 1 million )

This job is running since 5 days for a simple insert statement. When our DBA tried to kill oracle session related to this..nothing he found there.

I'm not able to stop the job through director.

How can stop it now ?

What would have happened ?

Suggestions please...

chulett · Post by **chulett** » Sun Jul 27, 2008 8:19 pm

Are there any processes related to the job still running? If you do a "ps -ef |grep phantom" does anything show up for this 5 day job?

suresh.narasimha · Post by **suresh.narasimha** » Tue Jul 29, 2008 1:44 am

Hi Chulett

Thanks for your reply.

ps -ef |grep phantom did not show my job name.

There are 2 sequences and a job running since 5 days.

I'm not able to compile those ....saying cannot give exclusive access..

Please suggest..

These 3 jobs are in production now.. i need to stop those and reimport from UAT.

i cannot restart Datastage server or the OS strictly.

Thanks & Best Regards

suresh.narasimha · Post by **suresh.narasimha** » Tue Jul 29, 2008 1:46 am

Hi Chulett

Thanks for your reply.

ps -ef |grep phantom did not show my job name.

There are 2 sequences and a job running since 5 days.

I'm not able to compile those ....saying cannot give exclusive access..

Please suggest..

These 3 jobs are in production now.. i need to stop those and reimport from UAT.

i cannot restart Datastage server or the OS strictly.

Thanks & Best Regards

rajngt · Post by **rajngt** » Tue Jul 29, 2008 5:49 am

As there is no oracle session and datastage process are running, do clear status file. In Datastage Director --> Job --> Clear status file.

chulett · Post by **chulett** » Tue Jul 29, 2008 7:47 am

Have you checked via the Director's 'Cleanup Resources'? Set it to show all processes and look for either your job name or number, then log it out.

ray.wurlod · Post by **ray.wurlod** » Tue Jul 29, 2008 4:32 pm

This is all so bad!

The "proper" way to abort a job (if there is any "proper" way, which I doubt) is to have some mechanism that the job sequence itself can detect, such as the existence/non-existence of a file.

suresh.narasimha · Post by **suresh.narasimha** » Tue Jul 29, 2008 5:25 pm

Hi All

Thanks for suggestions.

I have tried -

1. Clear status file - im not able to compile
2. Clean up resources and logout - not showing PID for the job.

So , i have renamed my jobs and imported into production.

But those jobs are " still working hard "

Please suggest me a solution ...just want to know

Cheers

chulett · Post by **chulett** » Tue Jul 29, 2008 7:08 pm

Suggest you look closer in the 'Cleanup Resources' panel. The "pid" won't always show based on the job name, sometimes you have to lookup the job number and then look for an RT_* entry with that number:

RT_CONFIGnnn
RT_LOGnnn

Etc.