| Author |
Message
|
| aman.kumar |
 Posted: Wed Aug 16, 2017 8:53 am Post subject: Strange behaviour from MQSC command |
 |
|
Newbie
Joined: 16 Aug 2017
Posts: 7
|
I noticed a strange behaviour from below MQSC command, I tried to filter out all the Channel Status where MCAUSER is "NOT" mqm but the command still returns me that.
dis chs(COMMON.BRK.SVRCONN) where (MCAUSER NE mqm)
12 : dis chs(COMMON.BRK.SVRCONN) where (MCAUSER NE mqm)
AMQ8417: Display Channel Status details.
CHANNEL(COMMON.BRK.SVRCONN) CHLTYPE(SVRCONN)
CONNAME(11.111.111.11) CURRENT
MCAUSER(mqm) STATUS(RUNNING)
SUBSTATE(RECEIVE)
AMQ8417: Display Channel Status details.
CHANNEL(COMMON.BRK.SVRCONN) CHLTYPE(SVRCONN)
CONNAME(11.111.111.11) CURRENT
MCAUSER(mqm) STATUS(RUNNING)
SUBSTATE(RECEIVE) |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Wed Aug 16, 2017 9:34 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
'mqm' is not the same as mqm.
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| aman.kumar |
| Posted: Wed Aug 16, 2017 10:22 am Post subject: |
|
|
Newbie
Joined: 16 Aug 2017
Posts: 7
|
dis chs(COMMON.BRK.SVRCONN) where (MCAUSER NE 'mqm')
2 : dis chs(COMMON.BRK.SVRCONN) where (MCAUSER NE 'mqm')
AMQ8417: Display Channel Status details.
CHANNEL(COMMON.BRK.SVRCONN) CHLTYPE(SVRCONN)
CONNAME(11.111.111.11) CURRENT
MCAUSER(mqm) STATUS(RUNNING)
SUBSTATE(RECEIVE)
AMQ8417: Display Channel Status details.
CHANNEL(COMMON.BRK.SVRCONN) CHLTYPE(SVRCONN)
CONNAME(11.111.111.11) CURRENT
MCAUSER(mqm) STATUS(RUNNING)
SUBSTATE(RECEIVE)
I got the same result |
|
| Back to top |
|
|
| JosephGramig |
| Posted: Wed Aug 16, 2017 10:44 am Post subject: |
|
|
Grand Master
Joined: 09 Feb 2006
Posts: 1244
Location: Gold Coast of Florida, USA
|
| You migh try where(MCAUSER NL 'mqm*'). I just read about the where clause... again. You should try it. |
|
| Back to top |
|
|
| aman.kumar |
| Posted: Wed Aug 16, 2017 11:31 am Post subject: |
|
|
Newbie
Joined: 16 Aug 2017
Posts: 7
|
Hi Joseph,
It worked.
| Quote: |
| You migh try where(MCAUSER NL 'mqm*'). I just read about the where clause... again. You should try it. |
something similar I am trying to do with "DIS QS" but I am having no luck
dis qs(Q1Q1) where(URTYPE NE QMGR)
9 : dis qs(Q1Q1) where(URTYPE NE QMGR)
AMQ8456: Conflicting parameters in command.
dis qs(Q1Q1) where(URTYPE NE 'QMGR')
10 : dis qs(Q1Q1) where(URTYPE NE 'QMGR')
AMQ8569: Error in filter specification
dis qs(Q1Q1) where(URTYPE NE 'QMGR'
AMQ8427: Valid syntax for the MQSC command:
DISPLAY display_cmd
WHERE( filter_keyword operator filter_value )
operator := [ LT | GT | EQ | NE | LE | GE | CT | EX | LK | NL | CTG | EXG ]
dis qs(Q1Q1) where(PID NE '14759')
11 : dis qs(Q1Q1) where(PID NE '14759')
AMQ8569: Error in filter specification
dis qs(Q1Q1) where(PID NE '14759'
AMQ8427: Valid syntax for the MQSC command:
DISPLAY display_cmd
WHERE( filter_keyword operator filter_value )
operator := [ LT | GT | EQ | NE | LE | GE | CT | EX | LK | NL | CTG | EXG ]
dis qs(Q1Q1) where(PID NE 14759)
12 : dis qs(Q1Q1) where(PID NE 14759)
AMQ8456: Conflicting parameters in command.
dis qs(T1T1) where(PID NL 1455)
20 : dis qs(M1M1) where(PID NL 1455)
AMQ8456: Conflicting parameters in command.
dis qs(T1T1) where(PID NL '1455*')
21 : dis qs(M1M1) where(PID NL '1455*')
AMQ8569: Error in filter specification |
|
| Back to top |
|
|
| aman.kumar |
| Posted: Wed Aug 16, 2017 12:25 pm Post subject: |
|
|
Newbie
Joined: 16 Aug 2017
Posts: 7
|
I figured it out, the right command is
dis qs(T1T1) type(handle) all where (PID NE 28882)
11 : dis qs(T1T1) type(handle) all where (PID NE 28882)
AMQ8565: Queue status not found. |
|
| Back to top |
|
|
|
|
