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: |
|
|
 Jedi
Joined: 25 Mar 2003 Posts: 2213 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: |
|
|
 Padawan
Joined: 09 May 2013 Posts: 1537 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 |
|
 |
|