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 SupportStrange behaviour from MQSC command

Post new topicReply to topic
Strange behaviour from MQSC command View previous topic :: View next topic
Author Message
aman.kumar
PostPosted: Wed Aug 16, 2017 8:53 am Post subject: Strange behaviour from MQSC command Reply with quote

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
View user's profile Send private message
mqjeff
PostPosted: Wed Aug 16, 2017 9:34 am Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17448

'mqm' is not the same as mqm.
_________________
chmod -R ugo-wx /
Back to top
View user's profile Send private message
aman.kumar
PostPosted: Wed Aug 16, 2017 10:22 am Post subject: Reply with quote

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
View user's profile Send private message
JosephGramig
PostPosted: Wed Aug 16, 2017 10:44 am Post subject: Reply with quote

Grand Master

Joined: 09 Feb 2006
Posts: 1180
Location: Derby City, USA

You migh try where(MCAUSER NL 'mqm*'). I just read about the where clause... again. You should try it.
Back to top
View user's profile Send private message AIM Address
aman.kumar
PostPosted: Wed Aug 16, 2017 11:31 am Post subject: Reply with quote

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
View user's profile Send private message
aman.kumar
PostPosted: Wed Aug 16, 2017 12:25 pm Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexIBM MQ Installation/Configuration SupportStrange behaviour from MQSC command
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.