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 IndexGeneral IBM MQ SupportOld unused MQ objects

Post new topicReply to topic
Old unused MQ objects View previous topic :: View next topic
Author Message
GheorgheDragos
PostPosted: Thu Mar 05, 2020 2:27 am Post subject: Old unused MQ objects Reply with quote

Apprentice

Joined: 28 Jun 2018
Posts: 31

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
View user's profile Send private message
bruce2359
PostPosted: Thu Mar 05, 2020 6:13 am Post subject: Re: Old unused MQ objects Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 8620
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?
_________________
My life flows on in endless song;
How can I keep from singing?
Back to top
View user's profile Send private message
PeterPotkay
PostPosted: Thu Mar 05, 2020 8:04 am Post subject: Re: Old unused MQ objects Reply with quote

Poobah

Joined: 15 May 2001
Posts: 7602

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
View user's profile Send private message
bruce2359
PostPosted: Thu Mar 05, 2020 8:14 am Post subject: Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 8620
Location: US: west coast, almost. Otherwise, enroute.

When apps are decommissioned, the objects used by those apps should also be decommissioned.
_________________
My life flows on in endless song;
How can I keep from singing?
Back to top
View user's profile Send private message
PeterPotkay
PostPosted: Thu Mar 05, 2020 8:25 am Post subject: Reply with quote

Poobah

Joined: 15 May 2001
Posts: 7602

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
View user's profile Send private message
bruce2359
PostPosted: Thu Mar 05, 2020 9:21 am Post subject: Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 8620
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. Doesnt hurt anyone.
_________________
My life flows on in endless song;
How can I keep from singing?
Back to top
View user's profile Send private message
gbaddeley
PostPosted: Thu Mar 05, 2020 2:41 pm Post subject: Reply with quote

Jedi

Joined: 25 Mar 2003
Posts: 2077
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
View user's profile Send private message
bruce2359
PostPosted: Thu Mar 05, 2020 4:53 pm Post subject: Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 8620
Location: US: west coast, almost. Otherwise, enroute.


Bart Simpson wrote:
You're damned if you do, damned if you don't

_________________
My life flows on in endless song;
How can I keep from singing?
Back to top
View user's profile Send private message
GheorgheDragos
PostPosted: Fri Mar 06, 2020 5:18 am Post subject: Reply with quote

Apprentice

Joined: 28 Jun 2018
Posts: 31

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

MQSeries.net Forum IndexGeneral IBM MQ SupportOld unused MQ objects
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.