| Author |
Message
|
| RangaKovela |
 Posted: Thu Jan 29, 2015 3:01 am Post subject: Expiring Indoubt transactions in MQv7 queue manager |
 |
|
Apprentice
Joined: 10 May 2011
Posts: 38
|
Hi MQ Experts,
Just want to check if there is any way to expire lingering MQ indoubt transactions on queue manager in MQ v7.0.1.x..External transaction managers is not able to commit or rollback such transactions.
Thanks, |
|
| Back to top |
|
 |
| PaulClarke |
| Posted: Thu Jan 29, 2015 4:22 am Post subject: |
|
|
Grand Master
Joined: 17 Nov 2005
Posts: 1002
Location: New Zealand
|
Are you talking about the command rsvmqtrn or do you want the transactions to just resolve automatically after some time period? Doing is automatically sounds a little hazardous to me.
Cheers,
Paul.
_________________
Paul Clarke
MQGem Software
www.mqgem.com |
|
| Back to top |
|
|
| zpat |
| Posted: Thu Jan 29, 2015 4:56 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
Do you mean to expire zombie transactions?
There is a an environment variable that can be used to control this. I don't think it's documented but the IBM support center provided it to us. We have it set to expire zombies after 60 minutes.
_________________
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: Thu Jan 29, 2015 4:59 am Post subject: Re: Expiring Indoubt transactions in MQv7 queue manager |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
| RangaKovela wrote: |
| Just want to check if there is any way to expire lingering MQ indoubt transactions on queue manager in MQ v7.0.1.x..External transaction managers is not able to commit or rollback such transactions. |
Which would be your preference? Commit or rollback? What external transaction manager?
_________________
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 |
|
|
| RangaKovela |
| Posted: Thu Jan 29, 2015 11:56 am Post subject: |
|
|
Apprentice
Joined: 10 May 2011
Posts: 38
|
| zpat wrote: |
Do you mean to expire zombie transactions?
There is a an environment variable that can be used to control this. I don't think it's documented but the IBM support center provided it to us. We have it set to expire zombies after 60 minutes. |
Yes, I mean zombie transactions. I see there are environment variables in MQ 7.5 but don't see any thing documented in MQ7.0
Can I use below MQ7.5 variables in MQ7 as well..
AMQ_TRANSACTION_EXPIRY_RESCAN=<rescan interval in milliseconds>
AMQ_XA_TRANSACTION_EXPIRY=<timeout interval in milliseconds> |
|
| Back to top |
|
|
| RangaKovela |
| Posted: Thu Jan 29, 2015 12:06 pm Post subject: Re: Expiring Indoubt transactions in MQv7 queue manager |
|
|
Apprentice
Joined: 10 May 2011
Posts: 38
|
| bruce2359 wrote: |
| RangaKovela wrote: |
| Just want to check if there is any way to expire lingering MQ indoubt transactions on queue manager in MQ v7.0.1.x..External transaction managers is not able to commit or rollback such transactions. |
Which would be your preference? Commit or rollback? What external transaction manager? |
Thanks Bruce for your response. Application team using Oracle WebLogic Server 11gR1 connecting to queue manager using Messaging bridges (using MQ XA client libraries).. Whenever messaging bridge encounters MQRC_CONNECTION_BROKEN exception a transaction is getting orphaned on queue manager. Such zombie transactions eventually growing in number and leading queue manager unresponsive. |
|
| Back to top |
|
|
|
|
