| Author |
Message
|
| PeterPotkay |
 Posted: Wed Dec 12, 2001 12:15 pm Post subject: |
 |
|
Poobah
Joined: 15 May 2001
Posts: 7722
|
Is there anyway to tell when the last time a queue was put to? Looking at all our MQ Objects on all our Queue Managers, I see that there are lots of queues that I "know" are obsolete. If I could generate a report somehow listing all queues and their last put time, we could scrutinize all older than say, six months, and start cleaning up.
_________________
Peter Potkay
Keep Calm and MQ On |
|
| Back to top |
|
 |
| bduncan |
| Posted: Wed Dec 12, 2001 10:13 pm Post subject: |
|
|
Padawan
Joined: 11 Apr 2001
Posts: 1554
Location: Silicon Valley
|
I'm not sure how to do this programmatically but I think that Candle's MQSeries monitoring tool keeps track of this statistic. Of course, that means you need to be running Candle 
_________________
Brandon Duncan
IBM Certified MQSeries Specialist
MQSeries.net forum moderator |
|
| Back to top |
|
|
| NickB |
| Posted: Thu Dec 13, 2001 1:38 am Post subject: |
|
|
Centurion
Joined: 20 May 2001
Posts: 107
Location: Zurich Financial Services
|
| Another way is to write a program which does a get-with-browse on all messages within each queue to determine the PutDate from the MQMD. It could then work out the most recent message for each queue. This of course would not be a fast process and would involve writing a program but it certainly wouldn't be too difficult. |
|
| Back to top |
|
|
| StefanSievert |
| Posted: Thu Dec 13, 2001 12:12 pm Post subject: |
|
|
Partisan
Joined: 28 Oct 2001
Posts: 333
Location: San Francisco
|
Nick,
that would imply that there actually are messages on a queue. I think what Peter wants is information about when an (empty) queue has been last used and the only way I know of to get this information is through MQ queue statistics. There are a couple of 3rd party products (e.g Candle Command Center) that provide this information. You could also write some PCF enabled program to obtain the information.
I guess this involves some reading...
Cheers,
Stefan
_________________
Stefan Sievert
IBM Certified * MQSeries
[ This Message was edited by: StefanSievert on 2001-12-13 12:12 ] |
|
| Back to top |
|
|
| EddieA |
| Posted: Thu Dec 13, 2001 1:31 pm Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
The only date/time maintained for a Queue is it's creation and last modification.
Maybe a way would be to use the RESET QUEUE STATISTICS (PCF). This returns the time since the last reset and the number of messages enqueued and dequeued since the last reset. So, you would have to store the date/time of the last check externaly somehow so you could build the history. Also, I'm not sure what happens to that time across a Queue Manager shut down and restart. Some experimentation required.
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
|
|
