Queue auto expire settings

Discussion:

Firoz Kotta

2013-09-21 13:03:46 UTC

Maybe there had been a discussion on this already and I missed it.

I have a development queue manager with thousands of queues. For one reason
or the other, a huge majority of these queues were never deleted. I wonder
whether IBM could add a configurable setting to the queue properties so
that a queue could get deleted after a preset interval.

I haven't considered opening a RFE. Just want to run this by the experts
here to see what you all think about this feature.

I do understand that stats can always be analyzed and action be taken based
on the data presented.

Scenario : A development queue manager may share resources amongst several
development teams. A set of queues gets created for this team. Dev team may
never run a cleanup job as they may be short on time during the release
efforts. A configurable property on the queue setting could automatically
delete the queues being used by the team, say after 6 months.

Best regards,

Firoz Kotta
(Cell) 732.470.9049
(Email) firoz.kotta-***@public.gmane.org
(vcard) http://firozkotta.businesscard2.com/

To unsubscribe, write to LISTSERV-0lvw86wZMd9k/bWDasg6f+***@public.gmane.org and,
in the message body (not the subject), write: SIGNOFF MQSERIES
Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://listserv.meduniwien.ac.at/archives/mqser-l.html

Dominique Courtois

2013-09-21 14:02:58 UTC

Permalink

Hi Firoz,
I remember (long ago) this was a typical case in the training course I used
to give.

The suggestion, as far as I remember, was to send a MQCMD_INQUIRE_Q PCF
command with a generic queue name. Then use the RetentionInterval and the
CreationDate of the returns against the current date to decide on queue
deletion with the MQCMD_DELETE_Q PCF command.

Help this can be useful.

Maybe the sample programs about PCF commands can be good starting points.

Regards

Dominique

To unsubscribe, write to LISTSERV-0lvw86wZMd9k/bWDasg6f+***@public.gmane.org and,
in the message body (not the subject), write: SIGNOFF MQSERIES

Tim Zielke

2013-09-21 15:41:16 UTC

Permalink

One option could be to require the developers to use a prefix like TEMP.2013.*

Then it would be trivial some time later in 2014 to delete the 2013 queues.

Tim

From: Firoz Kotta [mailto:firoz.kotta-8a+***@public.gmane.org]
Sent: Saturday, September 21, 2013 08:03 AM
To: MQSERIES-0lvw86wZMd9k/bWDasg6f+***@public.gmane.org <MQSERIES-0lvw86wZMd9k/bWDasg6f+***@public.gmane.org>
Subject: Queue auto expire settings

Maybe there had been a discussion on this already and I missed it.

I have a development queue manager with thousands of queues. For one reason or the other, a huge majority of these queues were never deleted. I wonder whether IBM could add a configurable setting to the queue properties so that a queue could get deleted after a preset interval.

I haven't considered opening a RFE. Just want to run this by the experts here to see what you all think about this feature.

I do understand that stats can always be analyzed and action be taken based on the data presented.

Scenario : A development queue manager may share resources amongst several development teams. A set of queues gets created for this team. Dev team may never run a cleanup job as they may be short on time during the release efforts. A configurable property on the queue setting could automatically delete the queues being used by the team, say after 6 months.

Best regards,

Firoz Kotta
(Cell) 732.470.9049
(Email) firoz.kotta-***@public.gmane.org<mailto:firoz.kotta-***@public.gmane.org>
(vcard) http://firozkotta.businesscard2.com/

________________________________
List Archive<http://listserv.meduniwien.ac.at/archives/mqser-l.html> - Manage Your List Settings<http://listserv.meduniwien.ac.at/cgi-bin/wa?SUBED1=mqser-l&A=1> - Unsubscribe<mailto:LISTSERV-0lvw86wZMd9k/bWDasg6f+***@public.gmane.org?subject=Unsubscribe&BODY=signoff%20mqseries>

Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com<http://www.lsoft.com/resources/manuals.asp>

To unsubscribe, write to LISTSERV-0lvw86wZMd9k/bWDasg6f+***@public.gmane.org and,
in the message body (not the subject), write: SIGNOFF MQSERIES
Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://listserv.meduniwien.ac.at/archives/mqser-l.html

Firoz Kotta

2013-09-21 16:53:29 UTC

Permalink

Hi Dominique,

That sounds like a very good idea. I also had overlooked the RETINTVL
setting on the queue while I had send this email.
Currently the value is set to the defaults on this setting. We had never
bothered changing it.

Best regards,

Firoz Kotta
(Cell) 732.470.9049
(Email) firoz.kotta-***@public.gmane.org
(vcard) http://firozkotta.businesscard2.com/

Post by Dominique Courtois
Hi Firoz,
I remember (long ago) this was a typical case in the training course I used
to give.
The suggestion, as far as I remember, was to send a MQCMD_INQUIRE_Q PCF
command with a generic queue name. Then use the RetentionInterval and the
CreationDate of the returns against the current date to decide on queue
deletion with the MQCMD_DELETE_Q PCF command.
Help this can be useful.
Maybe the sample programs about PCF commands can be good starting points.
Regards
Dominique
in the message body (not the subject), write: SIGNOFF MQSERIES
Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://listserv.meduniwien.ac.at/archives/mqser-l.html

To unsubscribe, write to LISTSERV-0lvw86wZMd9k/bWDasg6f+***@public.gmane.org and,
in the message body (not the subject), write: SIGNOFF MQSERIES
Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://listserv.meduniwien.ac.at/archives/mqser-l.html

Peter D

2013-09-21 17:07:15 UTC

Permalink

Infrared360 does this ... Common function in many companies, especially dev & qa groups.

Post by Firoz Kotta
Maybe there had been a discussion on this already and I missed it.
I have a development queue manager with thousands of queues. For one reason or the other, a huge majority of these queues were never deleted. I wonder whether IBM could add a configurable setting to the queue properties so that a queue could get deleted after a preset interval.
I haven't considered opening a RFE. Just want to run this by the experts here to see what you all think about this feature.
I do understand that stats can always be analyzed and action be taken based on the data presented.
Scenario : A development queue manager may share resources amongst several development teams. A set of queues gets created for this team. Dev team may never run a cleanup job as they may be short on time during the release efforts. A configurable property on the queue setting could automatically delete the queues being used by the team, say after 6 months.
Best regards,
Firoz Kotta
(Cell) 732.470.9049
(vcard) http://firozkotta.businesscard2.com/
List Archive - Manage Your List Settings - Unsubscribe
Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com

Barry Lamkin

2013-09-21 17:27:30 UTC

Permalink

And so does Omegamon 
 
 
 
 
 
 
 From:      
 Peter D <pdagosta-1chkMen6pVKh8MlnRdB+***@public.gmane.org>
 To:      
 MQSERIES-JX7+OpRa80QeFbOYke1v4oOpTq8/***@public.gmane.org,

 Date:      
 09/21/2013 01:07 PM
 Subject:    
   Re: Queue auto
expire settings
 Sent by:    
   MQSeries List
<MQSERIES-JX7+OpRa80QeFbOYke1v4oOpTq8/***@public.gmane.org>
 
<hr noshade>
 
 
 Infrared360 does this ... Common function in many companies,
especially dev & qa groups. 
 
On Sep 21, 2013, at 9:03 AM, Firoz Kotta <<a href=mailto:firoz.kotta-8a+***@public.gmane.org>firoz.kotta-8a+***@public.gmane.org</a>>
wrote: 

 Maybe there had been a discussion on this already and
I missed it. 
 
I have a development queue manager with thousands of queues. For one reason
or the other, a huge majority of these queues were never deleted. I wonder
whether IBM could add a configurable setting to the queue properties so
that a queue could get deleted after a preset interval. 

 I haven't considered opening a RFE. Just want to run this
by the experts here to see what you all think about this feature.
 
 I do understand that stats can always be analyzed and
action be taken based on the data presented.
 
 Scenario :  A development queue manager may share
resources amongst several development teams. A set of queues gets created
for this team. Dev team may never run a cleanup job as they may be short
on time during the release efforts. A configurable property on the queue
setting could automatically delete the queues being used by the team, say
after 6 months.
 
Best regards, 
 
Firoz Kotta 
(Cell)    732.470.9049 
(Email) <a href=mailto:firoz.kotta-***@public.gmane.org>firoz.kotta-***@public.gmane.org</a> 
(vcard) <a href=http://firozkotta.businesscard2.com/>http://firozkotta.businesscard2.com/</a>
 

<hr>
<div align=center><a href="http://listserv.meduniwien.ac.at/archives/mqser-l.html">List
Archive</a> - <a href="http://listserv.meduniwien.ac.at/cgi-bin/wa?SUBED1=mqser-l&A=1">Manage
Your List Settings</a> - <a href="mailto:LISTSERV-0lvw86wZMd9k/bWDasg6f+***@public.gmane.org?subject=Unsubscribe&BODY=signoff%20mqseries">Unsubscribe</a>

Instructions for managing your mailing list subscription
are provided in the Listserv General Users Guide available at <a href=http://www.lsoft.com/resources/manuals.asp>http://www.lsoft.com</a>
</div>
 

<hr>
<div align=center><a href="http://listserv.meduniwien.ac.at/archives/mqser-l.html">List
Archive</a> - <a href="http://listserv.meduniwien.ac.at/cgi-bin/wa?SUBED1=mqser-l&A=1">Manage
Your List Settings</a> - <a href="mailto:LISTSERV-0lvw86wZMd9k/bWDasg6f+***@public.gmane.org?subject=Unsubscribe&BODY=signoff%20mqseries">Unsubscribe</a>

Instructions for managing your mailing list subscription
are provided in the Listserv General Users Guide available at <a href=http://www.lsoft.com/resources/manuals.asp>http://www.lsoft.com</a>

</div>
 <hr><center>
<a href="http://listserv.meduniwien.ac.at/archives/mqser-l.html">List Archive</a> -
<a href="http://listserv.meduniwien.ac.at/cgi-bin/wa?SUBED1=mqser-l&A=1">Manage Your List Settings</a> -
<a href="mailto:LISTSERV-0lvw86wZMd9k/bWDasg6f+***@public.gmane.org?subject=Unsubscribe&BODY=signoff%20mqseries">Unsubscribe</a>

Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at <a href="http://www.lsoft.com/resources/manuals.asp">http://www.lsoft.com</a>

</center>

Peter D

2013-09-21 17:36:03 UTC

Permalink

Of course you guys got a 10+ year head start, so I would hope so in all that time :)

But the devil's always in the details Barry - and omegamon sure has a lot of configuration details. Kinda like one of those jokes about how many admins does it take to screw in a light bulb ;)

Seeya Monday in OH.

/Pete

Post by Barry Lamkin
And so does Omegamon
From: Peter D
Date: 09/21/2013 01:07 PM
Subject: Re: Queue auto expire settings
Infrared360 does this ... Common function in many companies, especially dev & qa groups.
Maybe there had been a discussion on this already and I missed it.
I have a development queue manager with thousands of queues. For one reason or the other, a huge majority of these queues were never deleted. I wonder whether IBM could add a configurable setting to the queue properties so that a queue could get deleted after a preset interval.
I haven't considered opening a RFE. Just want to run this by the experts here to see what you all think about this feature.
I do understand that stats can always be analyzed and action be taken based on the data presented.
Scenario : A development queue manager may share resources amongst several development teams. A set of queues gets created for this team. Dev team may never run a cleanup job as they may be short on time during the release efforts. A configurable property on the queue setting could automatically delete the queues being used by the team, say after 6 months.
Best regards,
Firoz Kotta
(Cell) 732.470.9049
(vcard) http://firozkotta.businesscard2.com/
List Archive - Manage Your List Settings - Unsubscribe
Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com
List Archive - Manage Your List Settings - Unsubscribe
Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com
List Archive - Manage Your List Settings - Unsubscribe
Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com

Paul Clarke

2013-09-21 17:21:50 UTC

Permalink

For any users of MO71 if you use this method of marking queues to expiry then you can define a simple filter in MO71 to display which queues have expired.
Something along along the lines of....

@qtime:=mqtime(crdate,crtime); @age#:=(_time - @qtime)/3600; @age# >= retintvl

Of course you can set this to filter name, say $expired, so you need only type $expired in the queue list window to see which queues ought to be deleted. This filter will also tell you the age, in hours, of the queue. If you do decide to delete the queues then it is merely a matter of selecting all the displayed queues and pressing âdeleteâ.

Cheers,
P.

Paul Clarke
www.mqgem.com

From: Firoz Kotta
Sent: Saturday, September 21, 2013 5:53 PM
To: MQSERIES-0lvw86wZMd9k/bWDasg6f+***@public.gmane.org
Subject: Re: Queue auto expire settings

Hi Dominique,

That sounds like a very good idea. I also had overlooked the RETINTVL setting on the queue while I had send this email.
Currently the value is set to the defaults on this setting. We had never bothered changing it.

Best regards,

Firoz Kotta
(Cell) 732.470.9049
(Email) firoz.kotta-***@public.gmane.org
(vcard) http://firozkotta.businesscard2.com/

On Sat, Sep 21, 2013 at 10:02 AM, Dominique Courtois <dominic77-***@public.gmane.org> wrote:

Hi Firoz,
I remember (long ago) this was a typical case in the training course I used
to give.

The suggestion, as far as I remember, was to send a MQCMD_INQUIRE_Q PCF
command with a generic queue name. Then use the RetentionInterval and the
CreationDate of the returns against the current date to decide on queue
deletion with the MQCMD_DELETE_Q PCF command.

Help this can be useful.

Maybe the sample programs about PCF commands can be good starting points.

Regards

Dominique

To unsubscribe, write to LISTSERV-0lvw86wZMd9k/bWDasg6f+***@public.gmane.org and,
in the message body (not the subject), write: SIGNOFF MQSERIES
Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://listserv.meduniwien.ac.at/archives/mqser-l.html

--------------------------------------------------------------------------------

List Archive - Manage Your List Settings - Unsubscribe
Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com

To unsubscribe, write to LISTSERV-0lvw86wZMd9k/bWDasg6f+***@public.gmane.org and,
in the message body (not the subject), write: SIGNOFF MQSERIES
Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://listserv.meduniwien.ac.at/archives/mqser-l.html

Peter D

2013-09-21 18:14:38 UTC

Permalink

Nice technique Paul.

IR360 does something similar (in a different way) for the 'auto-delete' averse :))
... They get their list & hit DEL.

... it seems the bigger the company the more averse to auto-anything, which seems odd since they have SO many more objects to manage!

/Pete

Post by Paul Clarke
For any users of MO71 if you use this method of marking queues to expiry then you can define a simple filter in MO71 to display which queues have expired.
Something along along the lines of....
@qtime:=mqtime(crdate,crtime); @age#:=(_time - @qtime)/3600; @age# >= retintvl
Of course you can set this to filter name, say $expired, so you need only type $expired in the queue list window to see which queues ought to be deleted. This filter will also tell you the age, in hours, of the queue. If you do decide to delete the queues then it is merely a matter of selecting all the displayed queues and pressing âdeleteâ.
Cheers,
P.
Paul Clarke
www.mqgem.com
From: Firoz Kotta
Sent: Saturday, September 21, 2013 5:53 PM
Subject: Re: Queue auto expire settings
Hi Dominique,
That sounds like a very good idea. I also had overlooked the RETINTVL setting on the queue while I had send this email.
Currently the value is set to the defaults on this setting. We had never bothered changing it.
Best regards,
Firoz Kotta
(Cell) 732.470.9049
(vcard) http://firozkotta.businesscard2.com/

List Archive - Manage Your List Settings - Unsubscribe
Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com
List Archive - Manage Your List Settings - Unsubscribe
Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com

Bruce Lerner

2013-09-21 18:50:55 UTC

Permalink

What if a queue is only used for year-end processing? Six month after
creation, it disappears. What if messages remain in the queue?

We get enough people complaining about MQ losing messages. Next we'll have
to respond to complaints about losing queues?!

To unsubscribe, write to LISTSERV-0lvw86wZMd9k/bWDasg6f+***@public.gmane.org and,
in the message body (not the subject), write: SIGNOFF MQSERIES

Peter D

2013-09-21 19:58:12 UTC

Permalink

Exactly why some don't do delete by rules. It is a choice and should be used by a diligent admin. As a line in one of my favorite movies says : "with great power comes great responsibility".

Though the original question was aimed towards Non-production Qmgrs.

Of course the real issue is collection of data and reporting on your queues, so that you know their usage. Reviewing these reports (or like IR360 does - let your biz unit review them with you) and see the traffic patterns on your queues ... Constant, weekly, monthly, yearly.

So thank you for the segway, as this is exactly what I'll be presenting at the MQTC on Monday & Tuesday. Hope to see you there!

/Pete

Post by Bruce Lerner
What if a queue is only used for year-end processing? Six month after
creation, it disappears. What if messages remain in the queue?
We get enough people complaining about MQ losing messages. Next we'll have
to respond to complaints about losing queues?!
in the message body (not the subject), write: SIGNOFF MQSERIES
Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://listserv.meduniwien.ac.at/archives/mqser-l.html

To unsubscribe, write to LISTSERV-0lvw86wZMd9k/bWDasg6f+***@public.gmane.org and,
in the message body (not the subject), write: SIGNOFF MQSERIES

Bruce Lerner

2013-09-21 20:14:07 UTC

Permalink

Though the original question was aimed towards Non-production Qmgrs."

Yes, indeed, it was. It's been my experience that both bad and good
behaviors practiced in TEST percolate to QA and PROD.

To unsubscribe, write to LISTSERV-0lvw86wZMd9k/bWDasg6f+***@public.gmane.org and,
in the message body (not the subject), write: SIGNOFF MQSERIES

Peter D

2013-09-21 20:22:13 UTC

Permalink

That can be true - as a former AAU coach I've been heard to repeat that mantra often! Something like 'if you guys practice like bleep, you'll play like bleep'. Yes we did use the bleep word @ times :)

/Pete

Post by Bruce Lerner
Though the original question was aimed towards Non-production Qmgrs."
Yes, indeed, it was. It's been my experience that both bad and good
behaviors practiced in TEST percolate to QA and PROD.
in the message body (not the subject), write: SIGNOFF MQSERIES
Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://listserv.meduniwien.ac.at/archives/mqser-l.html

To unsubscribe, write to LISTSERV-0lvw86wZMd9k/bWDasg6f+***@public.gmane.org and,
in the message body (not the subject), write: SIGNOFF MQSERIES