| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Old unused MQ objects |
« View previous topic :: View next topic » |
| Author |
Message
|
| GheorgheDragos |
 Posted: Thu Mar 05, 2020 2:27 am Post subject: Old unused MQ objects |
 |
|
Acolyte
Joined: 28 Jun 2018
Posts: 51
|
Dear MQ specialists,
I come to you with yet another question. Say one would want to do a general cleanup. Remove unused name lists, queues, processes, storage classes etc . How would one proceed ? One of my ideas is to have our queue statistics for two years ago processed with a rexx against a current list generated by MAKEDEF, so wahtever is in makedef but now in queue utilisation DSN, then it is a candidate for deletion. I do not know yet how I might proceed with name lists storage classes etc. Old messages I know how to list ( MSGAGE ), but objects ?
Thank you in advance for your time.
Dragos |
|
| Back to top |
|
 |
| bruce2359 |
| Posted: Thu Mar 05, 2020 6:13 am Post subject: Re: Old unused MQ objects |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
| GheorgheDragos wrote: |
| Say one would want to do a general cleanup. Remove unused name lists, queues, processes, storage classes etc . How would one proceed ? |
Very, very carefully. More than a few of my clients went down this same cleanliness path - to make MQ appear more pretty, less cluttered. Each subsequently discovered that they'd deleted some object rarely used.
While cleanliness is an admirable goal, what real value does this bring to the organization?
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
| PeterPotkay |
| Posted: Thu Mar 05, 2020 8:04 am Post subject: Re: Old unused MQ objects |
|
|
Poobah
Joined: 15 May 2001
Posts: 7722
|
| bruce2359 wrote: |
| While cleanliness is an admirable goal, what real value does this bring to the organization? |
If you never do it, eventually the majority of your environment is obsolete junk you have to deal with when trouble shooting, when migrating.
Monitoring tools can't tell what is obsolete or not, so they burn more cycles monitoring obsolete things than real things.
Displaying objects in your favorite admin tool for whatever the task is at hand takes longer to complete and takes longer to sort thru.
I don't need or want or can delete every obsolete object the minute its used the last time. But every so often (could be every few years!) its helpful to tidy up.
It does sometimes feel like work with low value and nothing but risk because you might delete something rarely used. For queues we suspect are obsolete, we get/put inhibit them, rely on Inhibit Events to tell us if someone is trying to use them. After a few weeks/months, delete the inhibited queues. We also rely on our monitoring tools to show how many messages were put to local queues in the last 13 months to identify candidates for inhibits. I do have an RFE for IBM to provide Put Counts for Alias and Remote Queues.
_________________
Peter Potkay
Keep Calm and MQ On |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Thu Mar 05, 2020 8:14 am Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
When apps are decommissioned, the objects used by those apps should also be decommissioned.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
| PeterPotkay |
| Posted: Thu Mar 05, 2020 8:25 am Post subject: |
|
|
Poobah
Joined: 15 May 2001
Posts: 7722
|
| bruce2359 wrote: |
| When apps are decommissioned, the objects used by those apps should also be decommissioned. |
Should being the operative work.
One day in a utopian future we will be able to say "When apps are decommissioned, the objects used by those apps are decommissioned. Always."
_________________
Peter Potkay
Keep Calm and MQ On |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Thu Mar 05, 2020 9:21 am Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
Unrelated. In my own utopian (delusional) world, I look quite like Sean Connery is his early acting days. Harmless. Doesn’t hurt anyone.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
| gbaddeley |
| Posted: Thu Mar 05, 2020 2:41 pm Post subject: |
|
|
Jedi Knight
Joined: 25 Mar 2003
Posts: 2538
Location: Melbourne, Australia
|
| bruce2359 wrote: |
| When apps are decommissioned, the objects used by those apps should also be decommissioned. |
Ideally, yes, and this usually happens if the MQ admin folks are engaged as part of the app decommission process. Quite often we are told the day before "the app server is going to be switched off", leaving little time to work out what MQ objects are impacted. In the ensuing weeks, we usually encounter other apps that are trying to send MQ messages or MFT files to the decommissioned app! Such is life.
_________________
Glenn |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Thu Mar 05, 2020 4:53 pm Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
| Bart Simpson wrote: |
You're damned if you do, damned if you don't
|
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
| GheorgheDragos |
| Posted: Fri Mar 06, 2020 5:18 am Post subject: |
|
|
Acolyte
Joined: 28 Jun 2018
Posts: 51
|
MQ Admins,
There are two options at play here.
1 - compare the list of queues from dis ql(*) etc against 335 PDS with statistics about queue utilisation, 1 PDS created per day.
2 - enable MONQ(low) on TST QSG and wait a week. What doesn't display a LGETDATE LPUTDATE is a candidate for deleting. Here is an article that points to this solution ( shout out to a colleague Mateusz who helped with this idea ).
https://www.ibm.com/support/pages/approaches-find-out-which-queues-are-active-queue-manager
Unfortunately, we have no ideas yet how to isolate stgclasses, namelists and processes.
Will keep the group updated.
Dragos |
|
| 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
|
|
|
|
