| Author |
Message
|
| immaculate |
 Posted: Tue Sep 23, 2014 4:02 am Post subject: Tracking messages at MQ level |
 |
|
Novice
Joined: 15 Sep 2014
Posts: 17
|
I heard that messages can be tracked and view with the MQ header details in GUI and by executing in DB with sql query. but not sure how.
can some one please explain how to track messages and how to configure to track them.
thanks in advance |
|
| Back to top |
|
 |
| hughson |
| Posted: Tue Sep 23, 2014 4:05 am Post subject: Re: Tracking messages at MQ level |
|
|
Padawan
Joined: 09 May 2013
Posts: 1959
Location: Bay of Plenty, New Zealand
|
| immaculate wrote: |
| I heard that messages can be tracked and view with the MQ header details in GUI and by executing in DB with sql query. but not sure how. |
This sounds like the description of a MQ tracking tool, i.e. an additional piece of software someone has written to allow the tracking of MQ messages and not part of the base MQ product. Perhaps you should ask the person you heard it from?
Cheers
Morag
_________________
Morag Hughson @MoragHughson
IBM MQ Technical Education Specialist
Get your IBM MQ training here!
MQGem Software |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Tue Sep 23, 2014 4:41 am Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
The dspmqrte utility comes to mind.
_________________
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 |
|
|
| hughson |
| Posted: Tue Sep 23, 2014 4:45 am Post subject: |
|
|
Padawan
Joined: 09 May 2013
Posts: 1959
Location: Bay of Plenty, New Zealand
|
| bruce2359 wrote: |
| The dspmqrte utility comes to mind. |
I'm not convinced there's any SQL query to a DB as part of dspmqrte.
_________________
Morag Hughson @MoragHughson
IBM MQ Technical Education Specialist
Get your IBM MQ training here!
MQGem Software |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Tue Sep 23, 2014 4:47 am Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
Yes, no SQL capabilities with dspmqrte. I stopped reading after how to trace the route ...?
_________________
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 |
|
|
| fjb_saper |
| Posted: Tue Sep 23, 2014 6:38 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Has me thinking of record and replay with IIB. But you need a different product for that... It is not part of core MQ. 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| zpat |
| Posted: Tue Sep 23, 2014 8:53 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
It could cause considerable overhead to log all messages to a database, so you would need to be selective about it.
There is a third-party product that uses the MQ API crossing exit to intercept messages and log them.
There is nothing in the IBM product and no free software to do this - unless you want to code your own 
_________________
Well, I don't think there is any question about it. It can only be attributable to human error. This sort of thing has cropped up before, and it has always been due to human error. |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Tue Sep 23, 2014 10:33 am Post subject: Re: Tracking messages at MQ level |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
| immaculate wrote: |
| I heard that messages can be tracked and view with the MQ header details in GUI and by executing in DB with sql query. but not sure how. |
MQ is not a database management application. MQ has no embedded database support. For the limited functionality of selecting specific messages for consumption/browsing, the API implements SQL-92, a subset of SQL.
Yes, you can use the MQ Explorer GUI to view MQMD details.
_________________
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 |
|
|
| immaculate |
| Posted: Wed Sep 24, 2014 12:42 am Post subject: |
|
|
Novice
Joined: 15 Sep 2014
Posts: 17
|
@zpat.
yes, that might be a third party tool or user defined , even their is a tool called MA0Z.
would like to know how to configure them to the website or DB , so that we can view them in website or by executing sql query.
@bruce2359
yes, i understand MQ is not a DB , but still i am sure that we can track messages not complete messsage but using any of few MQ header attributes.
thank you  [/u] |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Sep 24, 2014 5:00 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| immaculate wrote: |
@bruce2359
yes, i understand MQ is not a DB , but still i am sure that we can track messages not complete messsage but using any of few MQ header attributes. |
You can tell a specific message, before it's sent, to report on the route it takes.
You can't tell MQ "I sent a message last week, go tell me where it went, who it was processed by, and when".
The base MQ product does not do that by itself. |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Sep 24, 2014 5:23 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| immaculate wrote: |
| still i am sure that we can track messages not complete messsage but using any of few MQ header attributes. |
If you're sure then it must be true. 
I agree with my most worthy associate and the associated sentiments expressed.
The best you can get out of base MQ is a post-delivery report of what happened to a specific message; this report will be delivered immediately after the original message is delivered. It's on you to accept delivery of this report, interpret this report and (if you want a record you can query later) store it somewhere.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| exerk |
| Posted: Wed Sep 24, 2014 5:28 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
| Vitor wrote: |
| ...The best you can get out of base MQ is a post-delivery report of what happened to a specific message; this report will be delivered immediately after the original message is delivered... |
Provided the receiving end has set up the appropriate authorities etc.
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys. |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Wed Sep 24, 2014 5:31 am Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
| Vitor wrote: |
| The best you can get out of base MQ is a post-delivery report of what happened to a specific message; this report will be delivered immediately after the original message is delivered. It's on you to accept delivery of this report, interpret this report and (if you want a record you can query later) store it somewhere. |
You're not recommending COA and COD, are you? Both requesting and responding applications need to be coded to support these.
_________________
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 |
|
|
| mqjeff |
| Posted: Wed Sep 24, 2014 5:32 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| bruce2359 wrote: |
| Vitor wrote: |
| The best you can get out of base MQ is a post-delivery report of what happened to a specific message; this report will be delivered immediately after the original message is delivered. It's on you to accept delivery of this report, interpret this report and (if you want a record you can query later) store it somewhere. |
You're not recommending COA and COD, are you? Both requesting and responding applications need to be coded to support these. |
trace route messages. |
|
| Back to top |
|
|
| PeterPotkay |
| Posted: Wed Sep 24, 2014 5:40 am Post subject: |
|
|
Poobah
Joined: 15 May 2001
Posts: 7722
|
| bruce2359 wrote: |
| Vitor wrote: |
| The best you can get out of base MQ is a post-delivery report of what happened to a specific message; this report will be delivered immediately after the original message is delivered. It's on you to accept delivery of this report, interpret this report and (if you want a record you can query later) store it somewhere. |
You're not recommending COA and COD, are you? Both requesting and responding applications need to be coded to support these. |
Responding apps have nothing to do to make COAs and CODs work. The QM that owns the destination queue handles all that.
_________________
Peter Potkay
Keep Calm and MQ On |
|
| Back to top |
|
|
|
|
