| Author |
Message
|
| zpat |
 Posted: Tue Nov 15, 2011 3:34 am Post subject: Deleting uncommitted messages |
 |
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Tue Nov 15, 2011 1:04 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Split from old thread...
OK so let's be completely clear:
If your messages are subject to a 2 phase commit:
- The prepare for commit has not yet been executed:
your messages are "ghost" messages and are not reachable. There is no way you can access them. They usually get deleted during a qmgr restart.
- The prepare commit has been issued but obviously the commit / rollback has not been issued and the thread supposed to do this has lost connection:
Make sure you can stop the connection relative to the defunct thread. You should then be able to view the UOW with dspmqtrn. You will have to force commit to view the msgs, or force rollback to get rid of them...
You can also force commit look at them and delete them...
As our msgs were persistent we used to just bounce the qmgr and then force commit or force rollback...
Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| zpat |
| Posted: Tue Nov 15, 2011 1:42 pm Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
The application doing the PUT is a client channel attached program. This application has been restarted (hence the zero open count on the queue).
Not sure therefore how I would identify the connection. I can't see any channel connections from the IP address of that server.
I should say that I am progressing this issue now with IBM L2 support. |
|
| Back to top |
|
|
| zpat |
| Posted: Tue Nov 15, 2011 5:58 pm Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
|
| Back to top |
|
|
| fjb_saper |
| Posted: Tue Nov 15, 2011 10:15 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Well now you know you HAVE to upgrade...
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| zpat |
| Posted: Wed Nov 16, 2011 6:56 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
Yes, assuming they let me keep my job...  |
|
| Back to top |
|
|
|
|
