| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| DATA BASE Problem.. |
« View previous topic :: View next topic » |
| Author |
Message
|
| chanduy9 |
 Posted: Sun Aug 04, 2002 3:54 pm Post subject: DATA BASE Problem.. |
 |
|
Disciple
Joined: 28 Nov 2001
Posts: 177
Location: USA
|
Hi,
How the data base transactions will work in normal conditions...like i have one input, database,compute and two out put nodes. All error terminals are connected to error queue. My data base is updating even error occurs..but it has to roll back. I am using DB2 database.
The transaction mode is set to yes. Coordinate Transaction check box is not checked.
Thanks in advance..
Chandra. |
|
| Back to top |
|
 |
| kirani |
| Posted: Sun Aug 04, 2002 5:54 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Chandra,
If you want your Database updates to coordinate with MQSeries commit or rollback, you should use 2-phase commit. Your queue manager will act as transaction manager and your database manager will participate in global transaction as resource manager. You will have to configure your message flow to run in Coordinated Transaction mode. By default your transactions are broker coordinated.
For more information on how to configure 2-phase commit please refer to Chapter 12 in MQseries System Administration book.
_________________
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 |
|
|
| amigupta1978 |
| Posted: Sun Aug 04, 2002 8:03 pm Post subject: |
|
|
Centurion
Joined: 22 Jan 2002
Posts: 132
Location: India
|
Hi,
A lil more update on ur problem.
Actually when u connect the error/catch terminal of any node in MQSeries then when the error happens, the flow goes thru your catch/error terminal and if that path is successful it will COMMIT any changes it has made.
When msg flow backsout to either the MQinput terminal's failure node or goes back to input queue for backout then only it rollbacks any changes.
Regards,
Amit |
|
| Back to top |
|
|
| chanduy9 |
| Posted: Mon Aug 05, 2002 6:37 am Post subject: how to configure 2-phase commit in MQSI |
|
|
Disciple
Joined: 28 Nov 2001
Posts: 177
Location: USA
|
Hi,
I want to develop a message flow with commit/roll back. I want to update the data base if and only if the message is sucess, othere wise it has to roll back. Advice me...
Thanks,
Chandra. |
|
| Back to top |
|
|
| sgopal |
| Posted: Mon Aug 05, 2002 7:37 am Post subject: |
|
|
Acolyte
Joined: 30 Jul 2002
Posts: 63
|
| Again -> There are a couple of ways of doing this depending on your requirement. Please refer the MQseries System Administration and Developing Solutions in Websphere MQ Integrator books for details. Let me know if you have any further questions. |
|
| Back to top |
|
|
| kirani |
| Posted: Mon Aug 05, 2002 7:58 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Chandra,
As Amit said, you will have to design your message flow in such a way that all errors are thrown back to the MQInput node. For example,
MQInput(out)->Compute1->Database1->MQOutput1
MQInput(catch)->Trace1->...other nodes to handle error->MQOutput2->Throw1
In above message flow, if any error occurs in Out path of MQInput node, an Exception will be thrown and message will rollback to the MQInput node. In catch terminal, you will do your error processing and then Throw back the Exception to MQInput node for dB updates to rollback. Before you throw the error, you are going to log the error into Error queue using MQOuput2 node. Transaction mode for this node should be set to 'No'.
For more info pl go thru the Redbook suggested by sgopal.
_________________
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
|
|
|
|
