| Author |
Message
|
| Harshalw |
 Posted: Wed Jan 07, 2009 5:42 am Post subject: How to stop a wmb process on unix |
 |
|
Voyager
Joined: 23 Jul 2008
Posts: 77
|
Hi ,
My WMB application is updating some tables in DB2 on AIX. I see no reply from past 2 hrs . It seems there has been some deadlock. I wanted my application to stop processting further . How do i do that . Also there is another WMB application running which is updationg same process. However it is from windows. Please let me know how do i stop these 2 process. Pls this is very urgent.
Thanks n regards
Harshal. |
|
| Back to top |
|
 |
| Vitor |
| Posted: Wed Jan 07, 2009 5:46 am Post subject: Re: How to stop a wmb process on unix |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| Harshalw wrote: |
| Please let me know how do i stop these 2 process. |
The mqsistop command would seem a good place to start on the face of it. Failing that, I've always had good results with the kill command for stopping things.
(Can require a bit of ingenuity to start them again though!)
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| Harshalw |
| Posted: Wed Jan 07, 2009 6:40 am Post subject: |
|
|
Voyager
Joined: 23 Jul 2008
Posts: 77
|
mqsistop is not working in this case. The situation is two wmb exe - 1 on windows and other on AIX are referring to same table in db2. and there is deadlock. 
killed 1 process id .. still no reply .
pls help . |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Jan 07, 2009 6:43 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| Harshalw wrote: |
| killed 1 process id .. still no reply . |
Kill the other 
Also speak to your DBA about clearing the deadlock at a database level (there are actions he can take to help)
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| PeterPotkay |
| Posted: Wed Jan 07, 2009 11:38 am Post subject: |
|
|
Poobah
Joined: 15 May 2001
Posts: 7722
|
Did you try mqsitop -i after mqsistop failed?
_________________
Peter Potkay
Keep Calm and MQ On |
|
| Back to top |
|
|
|
|
