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 IndexIBM MQ Installation/Configuration SupportHow to combine WHERE statement in MQSC

Post new topicReply to topic
How to combine WHERE statement in MQSC View previous topic :: View next topic
Author Message
aman.kumar
PostPosted: Wed Aug 16, 2017 1:08 pm Post subject: How to combine WHERE statement in MQSC Reply with quote

Newbie

Joined: 16 Aug 2017
Posts: 7

Hello Experts,

I am trying to combine the WHERE statement during "DIS QSTATUS" but I am not getting any successful results, anyone here has tried that?


Following commands I tried but each time failed

#1.
echo "dis qs(T1T1) type(handle) all where (PID NE 14759 and TID EQ 1)" | runmqsc QMGR1

got an error as - AMQ8569: Error in filter specification


#2.
echo "dis qs(T1T1) type(handle) all where (PID NE 14759) AND (TID EQ 1)" | runmqsc QMGR1
This one failed too.

If someone knows a way around it, please share.
Back to top
View user's profile Send private message
mqjeff
PostPosted: Wed Aug 16, 2017 3:11 pm Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17448

MQSC is not designed to be a monitoring tool.

The WHERE clause is not designed to be a SELECT statement.

Write a PCF program. It's very easy using the java PCF classes.
_________________
chmod -R ugo-wx /
Back to top
View user's profile Send private message
gbaddeley
PostPosted: Wed Aug 16, 2017 5:09 pm Post subject: Reply with quote

Padawan

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

WHERE can only be specified once in a DISPLAY command, and it only supports one condition, and does not allow filtering on the object name. Its capabilities are therefore quite limited
_________________
Glenn
Back to top
View user's profile Send private message
hughson
PostPosted: Sat Aug 19, 2017 8:35 pm Post subject: Reply with quote

Shaman

Joined: 09 May 2013
Posts: 728
Location: Bay of Plenty, New Zealand

If you want multiple WHERE clauses you could of course look into MQSCX
_________________
Morag Hughson @MoragHughson
IBM MQ Technical Education Specialist
MQGem Software
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexIBM MQ Installation/Configuration SupportHow to combine WHERE statement in MQSC
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.