How to abort a job from back end process
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 81
- Joined: Mon Nov 21, 2005 4:17 am
- Location: Sydney, Australia
- Contact:
How to abort a job from back end process
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...
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...
SURESH NARASIMHA
-
- Premium Member
- Posts: 81
- Joined: Mon Nov 21, 2005 4:17 am
- Location: Sydney, Australia
- Contact:
How to abort a job from back end process
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
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
-
- Premium Member
- Posts: 81
- Joined: Mon Nov 21, 2005 4:17 am
- Location: Sydney, Australia
- Contact:
How to abort a job from back end process
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 81
- Joined: Mon Nov 21, 2005 4:17 am
- Location: Sydney, Australia
- Contact:
How to abort a job from back end process
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
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
SURESH NARASIMHA