kill job using job id
Moderators: chulett, rschirm, roy
kill job using job id
hi all,
i wud like to kill my job using kill cmd.
i tried to kill the job but cudn succeed.
is there any other to way
thanks in advance,
i wud like to kill my job using kill cmd.
i tried to kill the job but cudn succeed.
is there any other to way
thanks in advance,
vimal.R
Well, there's always the 'Stop' button in the Director. Other than that there's the operating system which can be used to end any process your have the permissions to put down. On UNIX that would be the 'kill' command against the appropriate PID.
Tell us what "i tried to kill the job but cudn succeed" means. What exactly did you try? What didn't work about it?
Tell us what "i tried to kill the job but cudn succeed" means. What exactly did you try? What didn't work about it?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
What you mean by 'kill'.
Do you want to delete or want to stop the process or need to release the lock?
If you are speaking about releasing the lock based on the job id, select the job name from the job id by executing SELECT NAME FROM DS_JOBS WHERE jobid = 'nnn' from TCL and after retreving the job name, you can got to director Jobs--->Cleanup Resource.
Click on Show All on the Locks tab and process.
Pick up the PIC for the job from the process tab, and select the PID on the Locks tab and click on 'Release All'.
Do you want to delete or want to stop the process or need to release the lock?
If you are speaking about releasing the lock based on the job id, select the job name from the job id by executing SELECT NAME FROM DS_JOBS WHERE jobid = 'nnn' from TCL and after retreving the job name, you can got to director Jobs--->Cleanup Resource.
Click on Show All on the Locks tab and process.
Pick up the PIC for the job from the process tab, and select the PID on the Locks tab and click on 'Release All'.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
If the job is hanging, then probably you want to unlock it. If thats what you are looking for then :
1. Goto the Datastage Adminstrator ( if you are privelaged) and login to the project.
2. Select the Project and click Command button.
3. Type in LIST.READU to list all the process.
4. Then type DS.Tools and enter option 4 and then option 7.
5. Enter the PID for the job to be unlocked.
6. You are done :D
1. Goto the Datastage Adminstrator ( if you are privelaged) and login to the project.
2. Select the Project and click Command button.
3. Type in LIST.READU to list all the process.
4. Then type DS.Tools and enter option 4 and then option 7.
5. Enter the PID for the job to be unlocked.
6. You are done :D
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
A DataStage parallel job consists of many processes - there is a conductor process, a section leader process on each processing node, and player processes on each processing node. Just from that description you should appreciate that kill is not the best way to stop a job - how could you be sure that you'd identified all the processes in the job?
That's why tools like Cleanup Resources and the DS.TOOLS menu exist.
That's why tools like Cleanup Resources and the DS.TOOLS menu exist.
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.
I would also like to add. If your job includes loading into a table and you want to stop that job, the best way is to just ask the DBA to kill your thread. That will send a connection lost message to your job and it will hance abort. IMHO, that is one of the best ways to handle hanged jobs (which includes loading a table). This also avoids any runway threads that might still be actively running even though the job was stopped or killed.
my 2 cents.
my 2 cents.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
No, the jobid and UNIX pid are not the same. It think in some places the pid is displayed, but DataStage has a another internal number for processes which is used, and the standard process-id and internal job id display in the PORT.STATUS command actually truncates long PIDs.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Add a ";" so that the engine knows that it is supposed to be a SQL query.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>