ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum IndexIBM MQ Installation/Configuration SupportLast time a queue was PUT to?

Post new topicReply to topic
Last time a queue was PUT to? View previous topic :: View next topic
Author Message
PeterPotkay
PostPosted: Wed Dec 12, 2001 12:15 pm Post subject: Reply with quote

Jedi Council

Joined: 15 May 2001
Posts: 7381

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
View user's profile Send private message
bduncan
PostPosted: Wed Dec 12, 2001 10:13 pm Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website AIM Address
NickB
PostPosted: Thu Dec 13, 2001 1:38 am Post subject: Reply with quote

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
View user's profile Send private message
StefanSievert
PostPosted: Thu Dec 13, 2001 12:12 pm Post subject: Reply with quote

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
View user's profile Send private message
EddieA
PostPosted: Thu Dec 13, 2001 1:31 pm Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexIBM MQ Installation/Configuration SupportLast time a queue was PUT to?
Jump to:



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
Protected by Anti-Spam ACP


Theme by Dustin Baccetti
Powered by phpBB 2001, 2002 phpBB Group

Copyright MQSeries.net. All rights reserved.