| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Message rollback |
« View previous topic :: View next topic » |
| Author |
Message
|
| BBM |
 Posted: Tue Mar 28, 2006 2:48 am Post subject: Message rollback |
 |
|
Master
Joined: 10 Nov 2005
Posts: 217
Location: London, UK
|
Hi,
We have seen a problem where a message appears to have been processed then rolled back to MQ.
Is there any way to look at past messages that have been rolled back?
I'm pretty sure they would not appear in the error logs as rollback would be transparent..
We have access to the logs via the Cressida tool and I am running a report now, has anyone got any other ideas?
Many thanks
BBM |
|
| Back to top |
|
 |
| wschutz |
| Posted: Tue Mar 28, 2006 2:52 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
If the messages have been rolled back, then the BackOutCount in the message descriptor will be incremented. That's the "best" way to know a message has been rolled back...
what logs are you referring to? the recovery logs or the error logs? No all messages hit the recovery logs (like non-persistent ones)
_________________
-wayne |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Mar 28, 2006 2:54 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
At the risk of grasping the wrong stick by the wrong end, a rolled back message would be on the original input queue with a backout count set. I don't think there's anything out of the box that does historical reporting, but presumably whatever it is that's clearing these unprocessed messages off the queue could be persuaded to do so?
Or have I got a stick in the wrong tree while I'm barking at it? 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| BBM |
| Posted: Tue Mar 28, 2006 3:07 am Post subject: |
|
|
Master
Joined: 10 Nov 2005
Posts: 217
Location: London, UK
|
Hi,
Thanks for the replies. The logs we are looking at are the recovery logs. As our messages are highly valuable we run reports using the recovery logs in the Cressida request tool from time to time to do spot reconciliations.
I accept not all messages are logged (all our messages are persistent by the way), I know that some 'get with waits' can result in persistent messages not being put down to the logs.
The messages are no longer on the input queue so i cannot check the backout count field although I have asked our DBAs to see if we store the message header in our tables (I'm guessing we strip out message data only).
Many thanks as always for the help.
BBM |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
