| Author |
Message
|
| mqlost |
 Posted: Fri Mar 10, 2006 8:52 am Post subject: How to remove an uncommitted message? |
 |
|
Newbie
Joined: 10 Feb 2006
Posts: 7
|
A client has done it again and has left me with uncommitted message on a Local Queue. Normally I would use dspmqtrn and then rsvmqtrn, but for this particulare message I don't get the transaction number. I had this problem before on a XmitQ but then I only had to stop the channel. However anything short from restarting the queuemanager hasn't given me the transaction number.
I did some more research to uncommitted messages and read that you can only use dpsmqtrn in the second phase of the two phase commit. I don't know what type of commit is being used by the application but I was wondering that if this means I can't use the dpsmqtrn because of this how am I ever going to get ride of the message? Will the restart of the queuemanager do it, cause I sincelerly doubt that at the moment. I am hoping you smartypants here can help me with this.  |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Fri Mar 10, 2006 1:59 pm Post subject: Re: How to remove an uncommitted message? |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| mqlost wrote: |
A client has done it again and has left me with uncommitted message on a Local Queue. Normally I would use dspmqtrn and then rsvmqtrn, but for this particulare message I don't get the transaction number. I had this problem before on a XmitQ but then I only had to stop the channel. However anything short from restarting the queuemanager hasn't given me the transaction number.
I did some more research to uncommitted messages and read that you can only use dpsmqtrn in the second phase of the two phase commit. I don't know what type of commit is being used by the application but I was wondering that if this means I can't use the dpsmqtrn because of this how am I ever going to get ride of the message? Will the restart of the queuemanager do it, cause I sincelerly doubt that at the moment. I am hoping you smartypants here can help me with this. |
Dealt with similar case earlier...
- Any message in a 2 phase commit that has been put to the queue will show in the queue depth
- If the client aborted before any prepare commit has been issued the message will not show up in dspmqtrn. The only way to get rid of it is to recycle the qmgr.
- If the client has issued a prepare commit before aborting you can rollback or force commit using a combination of dspmqtrn , grep, sed, rsvmqtrn...
Enjoy 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| mqlost |
| Posted: Mon Mar 13, 2006 2:30 am Post subject: |
|
|
Newbie
Joined: 10 Feb 2006
Posts: 7
|
Thanks for your answer.
With Recycle I think you mean a restart or do you mean something else? |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Mon Mar 13, 2006 3:54 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
endmqm + strmqm 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| SAFraser |
| Posted: Thu Mar 16, 2006 10:50 am Post subject: |
|
|
Shaman
Joined: 22 Oct 2003
Posts: 742
Location: Austin, Texas, USA
|
I've got to say, this post from mqlost just cracked me up!
I request that the term "Grand Master" be officially changed to "Smarty Pants".
Submitted with a respectful smile,
Shirley |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Mar 16, 2006 7:13 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Thanks for the accolade. Kiss on both cheeks.
F.J. 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
