| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Viewing Pending transactions? |
« View previous topic :: View next topic » |
| Author |
Message
|
| Dougster |
 Posted: Thu Jan 31, 2008 7:12 am Post subject: Viewing Pending transactions? |
 |
|
Novice
Joined: 04 Jul 2007
Posts: 12
|
Hello 
I was wondering if there is some tool we can use to view what pending messages, pending transactions, in-doubt transactions, etc
that an individual Queue and/or whole MQ server currently has.
Rather than having to stop the Queue manage and dump the active log.
I know you can use the dspmqtrn command but this only shows in-doudt messages.
Any help would be great thanks. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Jan 31, 2008 7:14 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Don't solve this problem at the MQ level.
Solve it at the application level.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Dougster |
| Posted: Thu Jan 31, 2008 7:39 am Post subject: |
|
|
Novice
Joined: 04 Jul 2007
Posts: 12
|
I will suggest that to the Dev team 
Although I won't hold my breath... |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Thu Jan 31, 2008 8:05 am Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
Affirming Jeff's comment:
MQ is only responsible for transporting messages containing your business data. Well written requesting and replying applications should be sensitive to loss or duplication of its business data.
With regard to MQ, the requesting (sending) application should keep track (in a database, for example) of requests that it has sent AND replies it has received. The replying application should keep track of requests received and replies sent. Both applications should recognize missing or duplicate transactions, and take appropriate action.
_________________
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 |
|
|
| jefflowrey |
| Posted: Thu Jan 31, 2008 9:13 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
That said, there are a number of different products out there that will let you get an enterprise view of your transactions, to monitor and track them.
But putting such a thing in place still doesn't excuse an application from it's responsibilities for it's own transactions.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| mvic |
| Posted: Sat Feb 02, 2008 3:34 pm Post subject: Re: Viewing Pending transactions? |
|
|
Jedi
Joined: 09 Mar 2004
Posts: 2080
|
| Dougster wrote: |
Hello
I was wondering if there is some tool we can use to view what pending messages, pending transactions, in-doubt transactions, etc
that an individual Queue and/or whole MQ server currently has. |
On a busy queue manager this list is constantly changing, maybe 100s of times a second, depending on system throughputs. Is it really helpful to see a snapshot at a particular instant in time?
| Quote: |
| Rather than having to stop the Queue manage and dump the active log. |
I guess you're not thinking of doing this - good. I say good because it will not reveal useful info to dump the log files in such circumstances. The only unfinished transactions that MQ will preserve across a restart are the Prepared ones. And these are the ones you get from dspmqtrn anyway.
| Quote: |
I know you can use the dspmqtrn command but this only shows in-doudt messages.
Any help would be great thanks. |
Interested to know, where / what use-case this requirement is coming from.. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
