| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Sorting messages on the queue |
« View previous topic :: View next topic » |
| Author |
Message
|
| Jenney |
 Posted: Thu Jun 21, 2007 11:48 am Post subject: Sorting messages on the queue |
 |
|
Voyager
Joined: 25 Apr 2007
Posts: 83
Location: Melbourne
|
Hi All,
I need to sort/filter messages date wise and analyze them. I have install and configured MQMON. I didn't find any thing in the pdf doc to filter messages in a queue based on date i.e. messages reached the queue.
Does any buddy have tried this through this tool or any other free tool.
Thanks in advance.
jen |
|
| Back to top |
|
 |
| JosephGramig |
| Posted: Thu Jun 21, 2007 12:41 pm Post subject: |
|
|
Grand Master
Joined: 09 Feb 2006
Posts: 1244
Location: Gold Coast of Florida, USA
|
Well, if the Queue is defined FIFO, then it will naturally be in that order. The date in the MQMD is when the application put the message. Not when the message arrived on to the queue you are reading from.
_________________
Joseph
Administrator - IBM WebSphere MQ (WMQ) V6.0, IBM WebSphere Message Broker (WMB) V6.1 & V6.0
Solution Designer - WMQ V6.0
Solution Developer - WMB V6.1 & V6.0, WMQ V5.3 |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Jun 21, 2007 1:04 pm Post subject: Re: Sorting messages on the queue |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| Jenney wrote: |
I need to sort/filter messages date wise and analyze them. I have install and configured MQMON. I didn't find any thing in the pdf doc to filter messages in a queue based on date i.e. messages reached the queue.
|
You can't sort them on the queue. The basic design of MQ is that messages don't sit on the queue long enough to be sorted. The best you can get is to unload them, sort them using external sort program of your choice and reload them.
I also concur with the observations of JosephGramig: FIFO messages are naturally in the order they arrived (not the order they were sent) and nothing in the message says when that occured.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Jun 21, 2007 5:41 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
A queue is not a database table.
Any program that assumes that the messages on the queue need to be processed in some kind of "sorted" order is likely trying to treat the queue as a database table.
_________________
I am *not* the model of the modern major general. |
|
| 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
|
|
|
|
