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 IndexGeneral IBM MQ SupportSVRCONN Chl instance used for GET or PUT??

Post new topicReply to topic Goto page 1, 2  Next
SVRCONN Chl instance used for GET or PUT?? View previous topic :: View next topic
Author Message
vicks_mq
PostPosted: Sat Apr 20, 2019 6:49 am Post subject: SVRCONN Chl instance used for GET or PUT?? Reply with quote

Disciple

Joined: 03 Oct 2017
Posts: 162

I did a STATUS on a SVRCONN channel - ABC.SVRCONN.CHL & I saw 2 instances are running and CONNNAME ip addresses in both are different.
Channel SUBSTATE in both of them is "RECEIVING". is there a way I can find out which one is being used to PUT request into Q and which one is used to "GET" reply by the application?
Back to top
View user's profile Send private message
PaulClarke
PostPosted: Sat Apr 20, 2019 9:15 am Post subject: Reply with quote

Guardian

Joined: 17 Nov 2005
Posts: 947
Location: New Zealand

I think perhaps what you need is the DISPLAY CONN command. If you issue the command

Code:
DISPLAY CONN(*) TYPE(ALL)

then you can see all the connections to the queue manager and the objects that have been opened by that connection. It will tell you if that connection was made across a channel and what the IP address of the client is. So, it is merely a question of looking for the returned record.

If your Queue Manager has a lot of activity then it can return a lot of data. You can try the WHERE clause, something like:

Code:
DISPLAY CONN(*) TYPE(ALL) WHERE(channel eq 'ABC.SVRCONN')



Hope this helps,

Paul.
_________________
Paul Clarke
MQGem Software
www.mqgem.com
Back to top
View user's profile Send private message Visit poster's website
vicks_mq
PostPosted: Sat Apr 20, 2019 10:06 am Post subject: Reply with quote

Disciple

Joined: 03 Oct 2017
Posts: 162

PaulClarke wrote:
I think perhaps what you need is the DISPLAY CONN command. If you issue the command

Code:
DISPLAY CONN(*) TYPE(ALL)

then you can see all the connections to the queue manager and the objects that have been opened by that connection. It will tell you if that connection was made across a channel and what the IP address of the client is. So, it is merely a question of looking for the returned record.


Hi Paul, I was able to get the IP address of the clients even from CHSTATUS-Conname parameter. I tried the above command and I got the following result, it still doesn't tell me the application connecting with this channel is doing PUT or GET?



DIS CONN(*) TYPE(ALL) WHERE(CHANNEL EQ ABC.TO.XYZ)
2 : DIS CONN(*) TYPE(ALL) WHERE(CHANNEL EQ ABC.TO.XYZ)
AMQ8276: Display Connection details.
CONN(B39FA95C97999C21)
EXTCONN(414D5143454149505247573220202020)
TYPE(*)
PID(21833) TID(213348)
APPLDESC(WebSphere MQ Channel)
APPLTAG(/opt/jboss/jboss-modules.jar)
APPLTYPE(USER) ASTATE(NONE)
CHANNEL(ABC.TO.XYZ) CLIENTID( )
CONNAME(IPAddress01)
CONNOPTS(MQCNO_HANDLE_SHARE_BLOCK,MQCNO_SHARED_BINDING)
USERID(mqappusr) UOWLOG( )
UOWSTDA( ) UOWSTTI( )
UOWLOGDA( ) UOWLOGTI( )
URTYPE(QMGR)
EXTURID(XA_FORMATID[] XA_GTRID[] XA_BQUAL[])
QMURID(0.0) UOWSTATE(NONE)
AMQ8276: Display Connection details.
CONN(B39FA95C539A9C21)
EXTCONN(414D5143454149505247573220202020)
TYPE(*)
PID(21833) TID(213348)
APPLDESC(WebSphere MQ Channel)
APPLTAG(/opt/jboss/jboss-modules.jar)
APPLTYPE(USER) ASTATE(NONE)
CHANNEL(ABC.TO.XYZ) CLIENTID( )
CONNAME(IPAddress01)
CONNOPTS(MQCNO_HANDLE_SHARE_BLOCK,MQCNO_SHARED_BINDING)
USERID(mqappusr) UOWLOG( )
UOWSTDA( ) UOWSTTI( )
UOWLOGDA( ) UOWLOGTI( )
URTYPE(QMGR)
EXTURID(XA_FORMATID[] XA_GTRID[] XA_BQUAL[])
QMURID(0.0) UOWSTATE(NONE)
AMQ8276: Display Connection details.
CONN(B39FA95C4E9B9C21)
EXTCONN(414D5143454149505247573220202020)
TYPE(*)
PID(21833) TID(213350)
APPLDESC(WebSphere MQ Channel)
APPLTAG(/opt/jboss/jboss-modules.jar)
APPLTYPE(USER) ASTATE(NONE)
CHANNEL(ABC.TO.XYZ) CLIENTID( )
CONNAME(IPAddress02)
CONNOPTS(MQCNO_HANDLE_SHARE_BLOCK,MQCNO_SHARED_BINDING)
USERID(mqappusr) UOWLOG( )
UOWSTDA( ) UOWSTTI( )
UOWLOGDA( ) UOWLOGTI( )
URTYPE(QMGR)
EXTURID(XA_FORMATID[] XA_GTRID[] XA_BQUAL[])
QMURID(0.0) UOWSTATE(NONE)
AMQ8276: Display Connection details.
CONN(B39FA95C4D9C9C21)
EXTCONN(414D5143454149505247573220202020)
TYPE(*)
PID(21833) TID(213350)
APPLDESC(WebSphere MQ Channel)
APPLTAG(/opt/jboss/jboss-modules.jar)
APPLTYPE(USER) ASTATE(NONE)
CHANNEL(ABC.TO.XYZ) CLIENTID( )
CONNAME(IPAddress02)
CONNOPTS(MQCNO_HANDLE_SHARE_BLOCK,MQCNO_SHARED_BINDING)
USERID(mqappusr) UOWLOG( )
UOWSTDA( ) UOWSTTI( )
UOWLOGDA( ) UOWLOGTI( )
URTYPE(QMGR)
EXTURID(XA_FORMATID[] XA_GTRID[] XA_BQUAL[])
QMURID(0.0) UOWSTATE(NONE)




Few observations of mine about the above result, the ASTATE is blank also UOWLOGTI is blank too.

If your Queue Manager has a lot of activity then it can return a lot of data. You can try the WHERE clause, something like:

Code:
DISPLAY CONN(*) TYPE(ALL) WHERE(channel eq 'ABC.SVRCONN')



Hope this helps,

Paul.[/u][/b][/i]
Back to top
View user's profile Send private message
PaulClarke
PostPosted: Sat Apr 20, 2019 10:14 am Post subject: Reply with quote

Guardian

Joined: 17 Nov 2005
Posts: 947
Location: New Zealand

The command
Code:
DISPLAY CONN(*) TYPE(ALL)
should show you two types of record, a connection record for each connection and a handle record for each object that that connection has open. The handle record will give the open options used for that handle and you can then work out whether the queue was open for put or get.

However, you don't seem to have any handle type records for these connections which leads me to think that either the command is not working on your machine for some reason or these connections haven't actually opened a queue. If you remove the WHERE clause do you see records containing OBJNAME and OPENOPTS from other connections ?

Cheers,

Paul.
_________________
Paul Clarke
MQGem Software
www.mqgem.com
Back to top
View user's profile Send private message Visit poster's website
vicks_mq
PostPosted: Sat Apr 20, 2019 12:25 pm Post subject: Reply with quote

Disciple

Joined: 03 Oct 2017
Posts: 162

Hi Paul,

command is working, I tried it with other channel, it seems only where ASTATE value is NONE, we are not getting OBJNAME and OPENOPTS

dis conn(*) type(all) where(channel eq HOME.CHANNEL)
4 : dis conn(*) type(all) where(channel eq HOME.CHANNEL)
AMQ8276: Display Connection details.
CONN(B39FA95C6CCC9E21)
EXTCONN(414D5143454149505247573220202020)
TYPE(*)
PID(21833) TID(224198)
APPLDESC(WebSphere MQ Channel) APPLTAG(MsgController)
APPLTYPE(USER) ASTATE(NONE)
CHANNEL(HOME.CHANNEL) CLIENTID( )
CONNAME(IPAddress3)
CONNOPTS(MQCNO_HANDLE_SHARE_BLOCK,MQCNO_SHARED_BINDING)
USERID(mqloser) UOWLOG( )
UOWSTDA( ) UOWSTTI( )
UOWLOGDA( ) UOWLOGTI( )
URTYPE(QMGR)
EXTURID(XA_FORMATID[] XA_GTRID[] XA_BQUAL[])
QMURID(0.0) UOWSTATE(NONE)
AMQ8276: Display Connection details.
CONN(B39FA95C76CD9E21)
EXTCONN(414D5143454149505247573220202020)
TYPE(*)
PID(21833) TID(224198)
APPLDESC(WebSphere MQ Channel) APPLTAG(MsgController)
APPLTYPE(USER) ASTATE(STARTED)
CHANNEL(HOME.CHANNEL) CLIENTID( )
CONNAME(IPAddress3)
CONNOPTS(MQCNO_HANDLE_SHARE_BLOCK,MQCNO_SHARED_BINDING)
USERID(mqloser) UOWLOG( )
UOWSTDA(2019-04-20) UOWSTTI(05.34.2
UOWLOGDA( ) UOWLOGTI( )
URTYPE(QMGR)
EXTURID(XA_FORMATID[] XA_GTRID[] XA_BQUAL[])
QMURID(0.24582) UOWSTATE(ACTIVE)

OBJNAME(HOME_LOCAL_QUEUE)
OBJTYPE(QUEUE) ASTATE(ACTIVE)
HSTATE(ACTIVE)
OPENOPTS(MQOO_INPUT_SHARED,MQOO_INQUIRE,MQOO_SAVE_ALL_CONTEXT,MQOO_FAIL_IF_QUIESCING)
READA(NO)
Back to top
View user's profile Send private message
vicks_mq
PostPosted: Sat Apr 20, 2019 12:34 pm Post subject: Reply with quote

Disciple

Joined: 03 Oct 2017
Posts: 162

[quote="vicks_mq"]Hi Paul,

command is working, I tried it with other channel, it seems only where ASTATE value is NONE, we are not getting OBJNAME and OPENOPTS

Further to add here - ASTATE is NONE and no OBJNAME and OPENOPTS when the channel opens the queue for Putting the messages.
Back to top
View user's profile Send private message
PaulClarke
PostPosted: Sat Apr 20, 2019 1:40 pm Post subject: Reply with quote

Guardian

Joined: 17 Nov 2005
Posts: 947
Location: New Zealand

You say that "it seems only where ASTATE value is NONE, we are not getting OBJNAME and OPENOPTS " but could it just be that those connections have not opened a queue ? If you believe they have opened a queue and this is not being shown in the command then I suggest you raise a PMR,

However, I am glad to hear that the command it at least shedding some light on the situation,


Cheers,

Paul.
_________________
Paul Clarke
MQGem Software
www.mqgem.com
Back to top
View user's profile Send private message Visit poster's website
vicks_mq
PostPosted: Sat Apr 20, 2019 2:00 pm Post subject: Reply with quote

Disciple

Joined: 03 Oct 2017
Posts: 162

PaulClarke wrote:
You say that "it seems only where ASTATE value is NONE, we are not getting OBJNAME and OPENOPTS " but could it just be that those connections have not opened a queue ? If you believe they have opened a queue and this is not being shown in the command then I suggest you raise a PMR,

However, I am glad to hear that the command it at least shedding some light on the situation,


Cheers,

Paul.

I think I know what is happening in cases where these properties are missing- the channel only make connection to QUEUE when it wants to put a message to the queue and it probably closes the connection to queue and it all probably happens in a fraction of a second. This is the reason we are not seeing any ObjName.
Back to top
View user's profile Send private message
PaulClarke
PostPosted: Sat Apr 20, 2019 2:04 pm Post subject: Reply with quote

Guardian

Joined: 17 Nov 2005
Posts: 947
Location: New Zealand

On the face of it it does seem more likely that the response to the command is correct and that it is telling you what the real situation is. Bugs do happen, of course, but on the whole IBM MQ is pretty reliable. Having said that we found two very bizarre (although not too serious) bugs with this very command only yesterday! One of the reasons why it was fresh in my mind.

Cheers,

Paul.
_________________
Paul Clarke
MQGem Software
www.mqgem.com
Back to top
View user's profile Send private message Visit poster's website
vicks_mq
PostPosted: Sun Apr 21, 2019 4:19 am Post subject: Reply with quote

Disciple

Joined: 03 Oct 2017
Posts: 162

PaulClarke wrote:
On the face of it it does seem more likely that the response to the command is correct and that it is telling you what the real situation is. Bugs do happen, of course, but on the whole IBM MQ is pretty reliable. Having said that we found two very bizarre (although not too serious) bugs with this very command only yesterday! One of the reasons why it was fresh in my mind.

Cheers,

Paul.


After couple of years working in MQ, I have realized MQ is slow in adding features where you can track historical transactions. Like it is hard for me to know when was the last message sent if the channel status become "inactive", only a running channel shows its last message time.
Similarly, impossible to know the last message put time on a particular REMOTE QUEUE , if the corresponding XMITQ is shared across multiple remote Queues.
Back to top
View user's profile Send private message
bruce2359
PostPosted: Sun Apr 21, 2019 8:11 am Post subject: Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 8525
Location: US: west coast, almost. Otherwise, enroute.

vicks_mq:
Please choose a high-contrast color for your posts. Orange is not one of those.
_________________
There are two types of people in this world:
1) Those that can extrapolate from incomplete data
Back to top
View user's profile Send private message
vicks_mq
PostPosted: Sun Apr 21, 2019 9:27 am Post subject: Reply with quote

Disciple

Joined: 03 Oct 2017
Posts: 162

bruce2359 wrote:
vicks_mq:
Please choose a high-contrast color for your posts. Orange is not one of those.


Site admin please remove these colors and bring some high contrast colors.
Back to top
View user's profile Send private message
bruce2359
PostPosted: Sun Apr 21, 2019 10:23 am Post subject: Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 8525
Location: US: west coast, almost. Otherwise, enroute.

vicks_mq wrote:
bruce2359 wrote:
vicks_mq:
Please choose a high-contrast color for your posts. Orange is not one of those.


Site admin please remove these colors and bring some high contrast colors.

Think of your audience - those from whom you seek help. My suggestion is to make your posts easier to read. You have choices when you post.

IMHO, yellow is a bad choice for readability. Cyan and violet follow a close second. Dark blue, black, red would seem to me to be easier to read.

Tiny font size would make reading a challenge, as well.
_________________
There are two types of people in this world:
1) Those that can extrapolate from incomplete data
Back to top
View user's profile Send private message
PeterPotkay
PostPosted: Sun Apr 21, 2019 12:16 pm Post subject: Reply with quote

Poobah

Joined: 15 May 2001
Posts: 7577

And this color is the worst!
_________________
Peter Potkay
Keep Calm and MQ On
Back to top
View user's profile Send private message
bruce2359
PostPosted: Sun Apr 21, 2019 2:41 pm Post subject: Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 8525
Location: US: west coast, almost. Otherwise, enroute.

Confetti also not preferable color scheme.
_________________
There are two types of people in this world:
1) Those that can extrapolate from incomplete data
Back to top
View user's profile Send private message
Display posts from previous:
Post new topicReply to topic Goto page 1, 2  Next Page 1 of 2

MQSeries.net Forum IndexGeneral IBM MQ SupportSVRCONN Chl instance used for GET or PUT??
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.