| Author |
Message
|
| nsakthi |
 Posted: Thu Oct 22, 2015 2:37 am Post subject: MQ statistics |
 |
|
Novice
Joined: 20 Dec 2012
Posts: 18
|
I have a requirement to know the statistics of message in a queue. The queue has 9 Million messages(accumulated over a week) which are sit in the queue for a dry-run testing. Application team needs to know some specific details from the statistics. I realize that MQ is not a DB to query in such a way. However I am curious to know if any tool / support pac serve this requirement.
1. Count of messages which are published on a particular day
2. Count of messages and on and after any date |
|
| Back to top |
|
 |
| zpat |
| Posted: Thu Oct 22, 2015 2:54 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
That is a huge number and any tool is going to run slowly.
You could use the QLOAD tool to unload the queue to a file using date range criteria and see how many messages get unloaded (you can delete the file or use /dev/null).
Make sure to run qload locally on the same host as the QM for this purpose.
Qload is support pac MO03 or the replacement in MQ v8 of dmpmqmsg
http://www-01.ibm.com/support/docview.wss?uid=swg24009368
_________________
Well, I don't think there is any question about it. It can only be attributable to human error. This sort of thing has cropped up before, and it has always been due to human error.
Last edited by zpat on Thu Oct 22, 2015 11:46 am; edited 1 time in total |
|
| Back to top |
|
|
| nsakthi |
| Posted: Thu Oct 22, 2015 3:44 am Post subject: MQ statistics |
|
|
Novice
Joined: 20 Dec 2012
Posts: 18
|
| Got it. Thanks for your response |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Oct 22, 2015 5:08 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| zpat wrote: |
| Qload is support pac MS03 |
Err. MO03.
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Oct 22, 2015 5:10 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Also you could modify amqsbcg to only print out the relevant parts of the mqmd (putdate/puttime)... and modify it to use a 1 byte long buffer.
Or pipe the output to something that would filter and only show/count the data you wanted.
Either choice is going to get slower the further down the queue you get. The first choice won't be as slow (maybe), and won't take nearly as much memory.
I think in order to really do what you wanted, you would have needed to capture the statistics as the messages were being put.
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| tczielke |
| Posted: Thu Oct 22, 2015 11:38 am Post subject: |
|
|
Guardian
Joined: 08 Jul 2010
Posts: 941
Location: Illinois, USA
|
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Oct 22, 2015 11:56 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mqjeff wrote: |
| I think in order to really do what you wanted, you would have needed to capture the statistics as the messages were being put. |
This is correct, but I think the OP is trying to gather this information for a large depth of messages that were put with this switched off. Hopefully the OP will take the advice to switch it on in future.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
