| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Configuring coordinated message flows |
« View previous topic :: View next topic » |
| Author |
Message
|
| Ching |
 Posted: Fri Apr 01, 2005 11:17 am Post subject: Configuring coordinated message flows |
 |
|
Apprentice
Joined: 08 Nov 2004
Posts: 25
Location: Portland, OR
|
Hi everyone,
I have a message flow that writes to 2 different database tables, and
if either are unsuccessful, I want both to roll back.
What is the best way for doing this?
Right now I'm doing a check if the SQL return code is NOT 0, then I'm manually deleting the rows that were just written. This works, but seems like a hokie way of doing this 'coordinated transaction'.
In the WBI Message Broker: Message Flows PDF on pg 51 it lists 3 different configurations that are required for coordinating transactions.
1. Message flow nodes need to be configured
2. Databases need to be configured (editing mq.ini file with XAResource manager)
3. MQ and RRS.
On pg 61, it says you might need to configure RRS. When would you need to configure this?
I'm a little unclear what needs to be added to the mq.ini file also.
If any of you have any advice I would appreciate it.
Also, in a different posting(http://www.mqseries.net/phpBB2/viewtopic.php?t=15405&highlight=xaresourcemanager), Timna suggested a 30% CPU hit when using XAResourceManager.
Is this even worth doing?
Thanks for your input!
Ching
|
|
| Back to top |
|
 |
| EddieA |
| Posted: Fri Apr 01, 2005 11:53 am Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
| Quote: |
| On pg 61, it says you might need to configure RRS. When would you need to configure this? |
RRS is only for z/OS. Are you running on z/OS. I guess not, because of:
| Quote: |
| I'm a little unclear what needs to be added to the mq.ini file also. |
Look up XA support in the manuals.
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| Ching |
| Posted: Mon Apr 04, 2005 8:37 am Post subject: |
|
|
Apprentice
Joined: 08 Nov 2004
Posts: 25
Location: Portland, OR
|
Message broker is running on AIX, and the DB2 tables are on Z/OS.
So I will need to configure the flow, the bar file, and
the qm.ini file with XAResource Manager only.
Nothing needs to be configured with RRS?
Is this correct?
Thanks for helping me get started.
Ching |
|
| 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
|
|
|
|
