| Author |
Message
|
| ashishsuvarna |
 Posted: Tue Mar 28, 2006 9:56 pm Post subject: How to read the MQ logs ?" |
 |
|
Apprentice
Joined: 25 Dec 2005
Posts: 30
Location: INDIA
|
Can anyone suggest me a technique as to "How to read the MQ logs ?" appart from referring it to the IBM guys.When I say logs here I mean the message logs and not the error logs.
_________________
Young techie |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue Mar 28, 2006 10:58 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You mean the binary, proprietary format log files that you can only translate into text if you stop the queue manager and use dmpmqlog?
Those logs?
No.
I have no idea how to read them.
It's a far far better thing to leave them alone and build your business process to meet your business needs, than to rely on infrastructure to satisfy business requirements.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| ashishsuvarna |
| Posted: Tue Mar 28, 2006 11:19 pm Post subject: |
|
|
Apprentice
Joined: 25 Dec 2005
Posts: 30
Location: INDIA
|
What I meant was the place where persistent messages are logged. Do we have to use dmpmqlog to translate and read those ?
_________________
Young techie |
|
| Back to top |
|
|
| fschofer |
| Posted: Tue Mar 28, 2006 11:24 pm Post subject: |
|
|
Knight
Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany
|
| Why do you want to do this ? |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Mar 28, 2006 11:24 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
I think a better question is why would you want to? What is the requirement here? Audit? Backup? Morbid curiosity?
There are alternative solutions to each of those needs without messing about in the plumbing.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| ashishsuvarna |
| Posted: Tue Mar 28, 2006 11:29 pm Post subject: |
|
|
Apprentice
Joined: 25 Dec 2005
Posts: 30
Location: INDIA
|
I have a requirement where people ask if a particular message has passed through a queue. If the message has left the queue ( say for eg consumed by an application ) is there anyway we can search the persistent message logs to find this out ? I know at the application side we can go and check the appliation logs but can this be done on MQ side ?
_________________
Young techie |
|
| Back to top |
|
|
| Michael Dag |
| Posted: Tue Mar 28, 2006 11:31 pm Post subject: |
|
|
Jedi Knight
Joined: 13 Jun 2002
Posts: 2607
Location: The Netherlands (Amsterdam)
|
|
| Back to top |
|
|
| markt |
| Posted: Tue Mar 28, 2006 11:35 pm Post subject: |
|
|
Knight
Joined: 14 May 2002
Posts: 508
|
There is NO WAY you can be sure, even from analysing the logs, whether something was read or not.
You might find evidence that it was read, but lack of evidence does not prove the opposite. Not everything is in the logs. (Obvious case is non-persistent messages - there are other non-obvious cases.) |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Mar 28, 2006 11:37 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
So you've an audit need. The business requires a searchable audit trail of messages consumed, this is a business need & should be part of the process not part of the technology.
This is the second time in an hour I've agreed with jefflowery. I must develop independant thought & stop stalking his posts. He's just such a role model for me.... 
Site I'm on at the moment has the sort of requirement you're talking about; the need to know if a particular message has been processed. This has been satisfied by the consuming application logging business relevent message keys (not MQMD information because it means nothing out of context), with a second application logging poison messages that never make it. Not the only solution to the problem, I make no claim for it nor it's applicability to your situation but it's simple, clean and easier than picking through the logs.
And works with the queue manager running.....! 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| ashishsuvarna |
| Posted: Tue Mar 28, 2006 11:55 pm Post subject: |
|
|
Apprentice
Joined: 25 Dec 2005
Posts: 30
Location: INDIA
|
Vitor,
If your talking about the CRESSIDIA site then I've seen it. If it is something else then let me know.
I know it is a business requirement and can be done easily at application side but was looking for an alternative. Anyway thanks guys for being so prompt and helpful.
_________________
Young techie |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Mar 29, 2006 12:06 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
No, it's not but I'm prevented from naming names in public. Sorry. 
You might also want to search this site for mirrorq, which is an out-of-the-box means of copying messages. These could then be stored someplace for your audit....?
Just a suggestion, again offered without predudice or favour.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| BBM |
| Posted: Wed Mar 29, 2006 12:18 am Post subject: |
|
|
Master
Joined: 10 Nov 2005
Posts: 217
Location: London, UK
|
Hi,
We are in the process of implementing a tool to solve a similiar problem.
Our requirement is to verify that a message reached our queue manager and was subsequently processed into our SQL database. We have been known to 'lose' messages between MQ and SQL (we use an intermediary app).
The reason we can't put this functionality into the upstream apps is that we have over 50 applications sending to us from around the globe. this would mean a significant amount of development.
Up until now we have been using the Request tool to run reports to verify message arrival. We are now looking at using API exits to dump every message to a second QM where we can reconcile at our leisure.
Unfortunately sometimes the business demands a solution that is infrastructure based - even when it should be application based.
Kind Regards
BBM |
|
| Back to top |
|
|
| wschutz |
| Posted: Wed Mar 29, 2006 2:27 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
|
| Back to top |
|
|
| Michael Dag |
| Posted: Wed Mar 29, 2006 2:37 am Post subject: |
|
|
Jedi Knight
Joined: 13 Jun 2002
Posts: 2607
Location: The Netherlands (Amsterdam)
|
AFAIK Transactionvision does not actually read the MQ log files,
but intercepts all MQI calls using an interceptor, so it may do a
better job also for non-persistent messages.
_________________
Michael
MQSystems Facebook page |
|
| Back to top |
|
|
| kevinf2349 |
| Posted: Wed Mar 29, 2006 6:24 am Post subject: |
|
|
Grand Master
Joined: 28 Feb 2003
Posts: 1311
Location: USA
|
Just a quick question here.....why not just use COA?
I admit it doesn't answer the subject of reading the logs, but it will tell you that the message made it to the target queue....and of course it does increase the overhead too.  |
|
| Back to top |
|
|
|
|
