| Author |
Message
|
| vicks_mq |
 Posted: Sat Apr 20, 2019 6:49 am Post subject: SVRCONN Chl instance used for GET or PUT?? |
 |
|
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 |
|
 |
| PaulClarke |
| Posted: Sat Apr 20, 2019 9:15 am Post subject: |
|
|
Grand Master
Joined: 17 Nov 2005
Posts: 1002
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 |
|
|
| vicks_mq |
| Posted: Sat Apr 20, 2019 10:06 am Post subject: |
|
|
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 |
|
|
| PaulClarke |
| Posted: Sat Apr 20, 2019 10:14 am Post subject: |
|
|
Grand Master
Joined: 17 Nov 2005
Posts: 1002
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 |
|
|
| vicks_mq |
| Posted: Sat Apr 20, 2019 12:25 pm Post subject: |
|
|
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 |
|
|
| vicks_mq |
| Posted: Sat Apr 20, 2019 12:34 pm Post subject: |
|
|
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 |
|
|
| PaulClarke |
| Posted: Sat Apr 20, 2019 1:40 pm Post subject: |
|
|
Grand Master
Joined: 17 Nov 2005
Posts: 1002
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 |
|
|
| vicks_mq |
| Posted: Sat Apr 20, 2019 2:00 pm Post subject: |
|
|
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 |
|
|
| PaulClarke |
| Posted: Sat Apr 20, 2019 2:04 pm Post subject: |
|
|
Grand Master
Joined: 17 Nov 2005
Posts: 1002
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 |
|
|
| vicks_mq |
| Posted: Sun Apr 21, 2019 4:19 am Post subject: |
|
|
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 |
|
|
| bruce2359 |
| Posted: Sun Apr 21, 2019 8:11 am Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9486
Location: US: west coast, almost. Otherwise, enroute.
|
vicks_mq:
Please choose a high-contrast color for your posts. Orange is not one of those.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
| vicks_mq |
| Posted: Sun Apr 21, 2019 9:27 am Post subject: |
|
|
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 |
|
|
| bruce2359 |
| Posted: Sun Apr 21, 2019 10:23 am Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9486
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.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
| PeterPotkay |
| Posted: Sun Apr 21, 2019 12:16 pm Post subject: |
|
|
Poobah
Joined: 15 May 2001
Posts: 7723
|
And this color is the worst!
_________________
Peter Potkay
Keep Calm and MQ On |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Sun Apr 21, 2019 2:41 pm Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9486
Location: US: west coast, almost. Otherwise, enroute.
|
Confetti also not preferable color scheme.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
|
|
