| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| MQSI transaction Control & 2-Phase commite |
« View previous topic :: View next topic » |
| Author |
Message
|
| Fady |
 Posted: Wed Jan 29, 2003 12:12 am Post subject: MQSI transaction Control & 2-Phase commite |
 |
|
Novice
Joined: 15 Jan 2003
Posts: 15
Location: Egypt , KSA
|
Hi there:
You guys adviced me before to read about 2-phase commite to control the unit of work in Message flows.
I need to have a transaction control on Message flow that call Stored procedure which do some effects in Database
the way , when the message flow Fail all these effects rolled back
when i read the Manual it says "You must configure external databases and MQSeries appropriately to enable this support. All actions in the message flow therefore either complete successfully, or are rolled back to the point where the original input message is restored on the input queue. This feature is controlled using the Coordinated Transaction property of the message flow: the default is for the transaction not to be globally coordinated. (Right-click on the message flow and select Properties.)"
when i right click on my message flow i can't find any Coordinated Transaction property !!!!
1- where can i configure this Coordinated Transaction property , is it in MQseries or in MQSI ?!
2- if any of you guys have a link or reference for configure MQSeries for Global transaction Coordinate, it will be gr8 to have it
thank you |
|
| Back to top |
|
 |
| lillo |
| Posted: Wed Jan 29, 2003 1:12 am Post subject: |
|
|
Master
Joined: 11 Sep 2001
Posts: 224
|
The Coordinated Transaction is configured in MQSeries. Take a look to the redbook "Developing Solutions in WebSphere MQ Integrator" where you could find the steps to configure the Coordinated Transaction and some examples of how to use it.
Cheers,
_________________
Lillo
IBM Certified Specialist - WebSphere MQ |
|
| Back to top |
|
|
| kirani |
| Posted: Thu Jan 30, 2003 9:24 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Also, take a look at Chapter 12 in MQSeries System Administrator Guide.
| Fady wrote: |
1- where can i configure this Coordinated Transaction property , is it in MQseries or in MQSI ?!
|
After you configure your queue manager for 2-phase commit, please follow these steps to run your message flow in Coordinated Transaction mode.
under Assignment Tab,
1. Check out your Execution Group.
2. Assign your message flow to Execution Group.
3. Right click on your message flow and then select properties.
4. Select Coordinated Transaction and then click on OK button.
5. Check-in your Execution Group.
6. Deploy your Execution Group.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| 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
|
|
|
|
