| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| How to roll back transactions |
« View previous topic :: View next topic » |
| Author |
Message
|
| sarvana |
 Posted: Thu Jan 20, 2005 10:10 pm Post subject: How to roll back transactions |
 |
|
Apprentice
Joined: 17 Jan 2005
Posts: 29
Location: India
|
Hi ,
I have a flow like this.An MQ input node and three compute nodes.At each stage of the flow ,I write some details to the table in DB2.At some point of time if I have an error in thge flow,I need to roll back all the transactions in the tables.Is this possible.
please help.
Thanks in advance.
_________________
SYstems Engineer ,
TCS,
India. |
|
| Back to top |
|
 |
| mqmhr |
| Posted: Thu Jan 20, 2005 10:23 pm Post subject: |
|
|
Centurion
Joined: 28 Dec 2004
Posts: 105
|
I am not sure about earlier versions, this is very much possible in
WBIMB 5.
You have to configure your broker queue manager and DB2 to participate in a globally coordinated transaction. This means that you have to change the XA Resource Manager settings in your queue manager and set the property "Coordinated Transaction" in your .bar file. Then restart your config manager, broker, queue manager, DB2 services and then it should work. |
|
| Back to top |
|
|
| getafix23 |
| Posted: Wed Jan 26, 2005 2:06 pm Post subject: |
|
|
Newbie
Joined: 26 Oct 2004
Posts: 9
|
| Are you using MQSI 2.1 or WBIMB 5? |
|
| Back to top |
|
|
| kirani |
| Posted: Thu Jan 27, 2005 12:01 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Please post WMQI related questions into WMQI forum.
To answer your question, yes it is possible to coordinate messaging activities and DB activities with-in a message flow by using 2-phase commit.
[Moving to WMQI Forum]
_________________
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
|
|
|
|
