| View previous topic :: View next topic |
| Author |
Message |
tomehta
Beginner
Joined: 19 Dec 2003
Posts: 17
Topics: 5
|
 Posted: Sat Aug 21, 2004 4:16 am Post subject: Supressin Mq trigger during syncpoint rollback |
 |
|
Hi
Can we suppress the trigger to the tranasaction when a rollback is done.
I have a sitauation in which i ca'nt use backout count in the application program. but whn there is a rollback it causes a infinte loop, as the trigger is again generated.
Regards |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Sat Aug 21, 2004 10:44 am Post subject: |
|
|
tomehta,
Why can't you use the BackoutCount field of MQMD? Another approach is by having your application turn triggering off after it connects to get the messages. If the process fails and the message has to be rolled back, triggering will be off. If the application is successfull, then it should turn triggering back on before it disconnects.
However remember that you have to consider that If your application dies before it can turn triggering back on, the messages will begin to pile up on the queue. If your application rolls back a bad message and triggering stays off, the whole system comes to a halt until a support person intervenes.
using the Backoutcount field is the right option.
Hope this helps...
Cheers
kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
Jeba
Beginner
Joined: 02 Dec 2002
Posts: 48
Topics: 9
Location: Columbus, GA
|
| Posted: Wed Sep 22, 2004 3:07 pm Post subject: |
|
|
Tomehta,
As Kolusu said, Using the Backout count will be the reight option.
We had similar looping problem in our application and we have solved the same using Backout count field of MQMD structure.
_________________
Thanks,
Jeba
(Known is a drop Unknown is an ocean) |
|
| Back to top |
|
|
bob_buxton
Beginner
Joined: 20 Dec 2002
Posts: 44
Topics: 0
Location: Hampshire, England
|
| Posted: Wed Sep 29, 2004 8:50 am Post subject: |
|
|
You don't explain why you can't use Backout count - it is the normal method for handling backed out messages.
A more esoteric option is to use the Mark Skip Backout option. This allows you to specify that a message is not to be immediately backed out during rollback. See the MQ APR for details.
_________________
Bob Buxton
Ex Websphere MQ for zOS development |
|
| Back to top |
|
|
bob_buxton
Beginner
Joined: 20 Dec 2002
Posts: 44
Topics: 0
Location: Hampshire, England
|
| Posted: Wed Sep 29, 2004 8:50 am Post subject: |
|
|
You don't explain why you can't use Backout count - it is the normal method for handling backed out messages.
A more esoteric option is to use the Mark Skip Backout option. This allows you to specify that a message is not to be immediately backed out during rollback. See the MQ APR for details.
_________________
Bob Buxton
Ex Websphere MQ for zOS development |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
