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 Index » General IBM MQ Support » command line for finding queues

Post new topic  Reply to topic
 command line for finding queues « View previous topic :: View next topic » 
Author Message
inMo
PostPosted: Tue Mar 07, 2017 6:20 am    Post subject: command line for finding queues Reply with quote

Master

Joined: 27 Jun 2009
Posts: 216
Location: NY

Hi - I'm looking to find all queues that contain a unique indicator in the Description. I've run the following command:

Code:
DIS Q(*) WHERE(DESCR LK MQ*)


It turns out that over time, folks placed the unique indicator in various spots in the description. Is there a way to locate an indicator anywhere in the description vs. at the beginning?

Thanks.
Back to top
View user's profile Send private message
bruce2359
PostPosted: Tue Mar 07, 2017 10:45 am    Post subject: Reply with quote

Poobah

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

If WHERE isn't granular enough, then pass DIS QL(*) DESCR output to A shell script
_________________
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
View user's profile Send private message
mqjeff
PostPosted: Tue Mar 07, 2017 12:22 pm    Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447

Write a script using dmpmqcfg.

Parse the DESC fields of all queues, to pull out the unique id.

Run an ALTER on all the queues, putting the id at the front of the DESC .

Put a gate in place that doesn't let people put the ID anywhere else...
_________________
chmod -R ugo-wx /
Back to top
View user's profile Send private message
PaulClarke
PostPosted: Wed Mar 08, 2017 12:58 am    Post subject: Reply with quote

Grand Master

Joined: 17 Nov 2005
Posts: 1002
Location: New Zealand

Alternatively you could use MQSCX (http://www.mqgem.com/mqscx.html)

This would allow either of the following.....

Code:
dis q(*) =find(mytext)


or being more specific

Code:
dis q(*) =where(desc == '*mytext*')


plus other programmatic mechanisms if you wanted to get really clever.

Cheers,

Paul.
_________________
Paul Clarke
MQGem Software
www.mqgem.com
Back to top
View user's profile Send private message Visit poster's website
gbaddeley
PostPosted: Wed Mar 08, 2017 3:16 pm    Post subject: Reply with quote

Jedi

Joined: 25 Mar 2003
Posts: 2492
Location: Melbourne, Australia

If you are on UNIX, here is some shell script code to parse the multi-line output of DIS Q into single lines, and grep for contents of description. Feel free to hack / improve. Not as nice or easy as MQSCX.
Code:
#!/usr/bin/ksh
QMGRNAME="MYQMGRNAME"
QNAMESPEC="MYQUEUES.*"
QLISTFILE="qlist.out"
DESCPATTERN="FOOBAR"
echo "dis q('$QNAMESPEC') descr" | runmqsc $QMGRNAME | awk 'function getv(j) { return(substr($0,j,index(substr($0,j),")")-1)) }
  BEGIN { qn=desc="?" }
  { i=index($0,"QUEUE(") ; if(i>0) qn=getv(i+6)
    i=index($0,"DESCR(") ; if(i>0) desc=getv(i+6)
    if($1~/^A/ && qn!="?") {
      print "name=" qn ",desc=" desc
      qn=desc="?"
     }
  }' >$QLISTFILE
grep ,desc=.*$DESCPATTERN $QLISTFILE

_________________
Glenn
Back to top
View user's profile Send private message
PaulClarke
PostPosted: Wed Mar 08, 2017 3:51 pm    Post subject: Reply with quote

Grand Master

Joined: 17 Nov 2005
Posts: 1002
Location: New Zealand

Thank you for the endorsement. I have to applaud your ingenuity for a solution. However, it always amazes me that people will go to such lengths to write a script rather than buying a tool for the job. A tool by the way, in the case of MQSCX, that costs less then a couple of hours pay. There are many problems with these types of scripts in my opinion but these are the main ones....
  • They are complicated
    This may seem really obvious but it is a real problem. Even this very simple problem has resulted in a script which many people would struggle to write let alone modify. As the problem description gets broader, which it often does, the solution often gets exponentially more complicated.

  • Very difficult to prove correctness
    When you are cobbling together lots of tools to get a result when they weren't designed for the job it can be very hard to tell whether you have it written it correctly.

  • Ongoing maintenance
    It is bad enough trying to maintain these types of scripts yourself but many people inherit scripts like these from colleagues who have 'moved on'. The amount of time spent trying to relearn what was intended can easily pay for a suitable tool. Add to that the cost of getting something wrong and I fail to see how buying suitable tools is hard to justify.

  • Employee Satisfaction
    There is no doubt there is some satisfaction to be gained by coming up with a neat thing built from things you found lying around in the basement. But it is hard work, especially when you don't have the proper tools. It is far more fun and rewarding to build much better things by having tools that make it easier. For example, suppose you thought you'd write a name validation script to ensure the integrity of your MQ estate. How many of us would even attempt such a thing using the script language you mention. However, with something like MQSCX it is not only viable but easy. Having good tools actually encourages people to go out and build things, to make things better, more robust, more secure and less error prone.

Just my two cents worth. Others may disagree, as a vendor clearly I am biased

Cheers,
Paul.
_________________
Paul Clarke
MQGem Software
www.mqgem.com
Back to top
View user's profile Send private message Visit poster's website
smdavies99
PostPosted: Wed Mar 08, 2017 11:30 pm    Post subject: Reply with quote

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

Paul,
Yes, your tools are great and solve all sorts of problems but for many people the process of getting the purchase of them in large orgs is just far too stressful.

1) Some companies only buy from Qualified Vendors. To get on the QVL can take 6 months
2) Some companies that are really under thumb of the bean counters don't have a Low Value Purchace Order system. See QVL above.
3) Buying these low value items on expenses and {cough, cough} passing them off can be a case for an immediate dismissal.
4) Getting any Capex approved can require approval almost at BOD level

Then getting the process repeated year after year... Arrgggghhhh my brain hurts.

I tried selling software 10-12 years ago. I had lots of people interested but almost none turned into orders for these reasons.
In the end, I got some income by billing the companies for a day's training in the product. That seemed to require less scrutiny and approvals. I gave them the softwre for free. Two days and they got the sources as well.
It worked reasonable well until the Credit Crunch hit.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.
Back to top
View user's profile Send private message
PaulClarke
PostPosted: Wed Mar 08, 2017 11:59 pm    Post subject: Reply with quote

Grand Master

Joined: 17 Nov 2005
Posts: 1002
Location: New Zealand

You are right of course, it is always harder than it should be. Somehow straight forward logic doesn't work on these people. Luckily not all companies are under the thumb of the bean counters. It is perhaps a shame though that more don't recognise the difference between visible and invisible costs.

Cheers,
Paul.
_________________
Paul Clarke
MQGem Software
www.mqgem.com
Back to top
View user's profile Send private message Visit poster's website
gbaddeley
PostPosted: Thu Mar 09, 2017 3:18 pm    Post subject: Reply with quote

Jedi

Joined: 25 Mar 2003
Posts: 2492
Location: Melbourne, Australia

Quote:
Paul: However, it always amazes me that people will go to such lengths to write a script rather than buying a tool for the job.

Many scripts were written 10-20 years ago when MQ was first introduced into the organisation. In general they are not changed unless they break because of an MQ upgrade or OS upgrade. It is difficult to convince management of the ROI to purchase, deploy and maintain new ISV tools on hundreds of servers when what we have works adequately.
_________________
Glenn
Back to top
View user's profile Send private message
bruce2359
PostPosted: Thu Mar 09, 2017 9:28 pm    Post subject: Reply with quote

Poobah

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

I'm all in favor of licensed software, rather than home-grown. That said, if I can't attach tooling to a project, then local scripting is most likely. As always, mgt must sign off on either position as to costs and maintenance.
_________________
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
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » General IBM MQ Support » command line for finding queues
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.