MQSeries.net :: View topic - req mqsc command query with multiple where conditions

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » General IBM MQ Support » req mqsc command query with multiple where conditions

req mqsc command query with multiple where conditions

« View previous topic :: View next topic »

Author

Message

vishnurajnr

Posted: Wed Mar 09, 2016 5:39 am Post subject: req mqsc command query with multiple where conditions

Centurion

Joined: 08 Aug 2011
Posts: 134
Location: Trivandrum

Hi All,

Is there anything like we can issue mqsc command with multiple where conditions?

My intention is to quickly find the queue names which are opened by MQ Java clients (JMS) for read

Something like

Quote:

dis qs(*) TYPE(HANDLE) where (APPLTAG eq 'Websphere MQ Client for Java') & (OUTPUT eq 'YES')

MQ Version:8.0.0.4
OS: Win and Linux

Thanks

mqjeff

Posted: Wed Mar 09, 2016 5:48 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

I don't believe that base MQ supports this.

You could of course do your own PCF checking and sorting. Or do a grep/find on runmqsc.

I'm 95% sure that at least the MQGem version of M071/MO72 supports this.
_________________
chmod -R ugo-wx /

vishnurajnr

Posted: Wed Mar 09, 2016 7:04 am Post subject:

Centurion

Joined: 08 Aug 2011
Posts: 134
Location: Trivandrum

mqjeff wrote:

I'm 95% sure that at least the MQGem version of M071/MO72 supports this.

Thanks a lot mqjeff. mqmon toll helped me here.

PaulClarke

Posted: Wed Mar 09, 2016 2:46 pm Post subject:

Grand Master

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

Yes, both MQGem products allow this (and far more besides).

MQSCX - if you want to have a command line
you can see a video describing some of the additional filtering here https://www.youtube.com/watch?v=6mZt6rDEhNM

MO71 - if you want to do it in a GUI
you can see a video demonstrating filtering in MO71 here https://www.youtube.com/watch?v=oAnD5cMa74k

Hope that helps,

Paul.
_________________
Paul Clarke
MQGem Software
www.mqgem.com

vishnurajnr

Posted: Wed Mar 09, 2016 8:43 pm Post subject:

Centurion

Joined: 08 Aug 2011
Posts: 134
Location: Trivandrum

Thanks Paul.. Nice to see the video tutorials... Its a new learning to me...

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » General IBM MQ Support » req mqsc command query with multiple where conditions

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