Posted: Tue May 13, 2003 11:37 am Post subject: Retry transaction in case of deadlock
Acolyte
Joined: 31 Dec 1969 Posts: 73
Hi,
Is there any setting on the message flow or database nodes to retry transactions in case of deadlocks or timeout errors?
I can think the only other way will be to catch the exception and loop it inside the message flow. But this will involve keepng count of number of retries inside the message. And I dont want to add any new fields to the message.
Joined: 05 Sep 2001 Posts: 3779 Location: Torrance, CA, USA
To achieve this keep the Catch terminal of the MQInput node unconnected and increase the BackoutThreshold property of your Input queue to greater than 0.
For each error WMQI will try to process your message N+1 times (where N is the value of BackoutThreshold).
If you cannot leave the "Catch Terminal" unconnected then make sure your Catch processing ends with the Throw node. _________________ Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
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