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.
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.
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.
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.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum