| Author |
Message
|
| aman.kumar |
 Posted: Wed Aug 16, 2017 1:08 pm Post subject: How to combine WHERE statement in MQSC |
 |
|
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 |
|
 |
| mqjeff |
| Posted: Wed Aug 16, 2017 3:11 pm Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
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 |
|
|
| gbaddeley |
| Posted: Wed Aug 16, 2017 5:09 pm Post subject: |
|
|
Padawan
Joined: 25 Mar 2003
Posts: 1829
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 |
|
|
| hughson |
| Posted: Sat Aug 19, 2017 8:35 pm Post subject: |
|
|
Shaman
Joined: 09 May 2013
Posts: 775
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
Get your IBM MQ training here!
MQGem Software |
|
| Back to top |
|
|
|
|
