Two-Phase Commit between DB2 (on AS400) and SQL Server (on Windows Server) using BizTalk Server Adapters
I want to achieve a two phase commit between a DB2 database (hosted on a AS400 system) and a SQL Server
(hosted on a Windows server) using BizTalk Server Adapters. Is this possible ? If yes, is there some
article/walkthrough that can explain how it is done ?
March 30th, 2015 9:31am
According to my experience, I'm afraid this is not feasible.
Free Windows Admin Tool Kit Click here and download it now
April 2nd, 2015 2:31am
Hi Ioakim
Does the scenario involve reading/deleting a record from DB2 and then inserting/updating that in SQL Server?
In this case, you have to break this up as two different transactions/two-phase commits. One between DB2 and BizTalk MessageBoxDB to read the data. And the second transaction on the BizTalk Send Port between BizTalk MessageBoxDB and your custom SQL DB.
Regards
Arindam
April 2nd, 2015 4:00pm
What I want to achieve is :
a) update/insert/delete in DB2 database
b) update/insert/delete in SQL database
both actions implemented on the same transaction, and if something goes wrong on either end, to rollback both actions (that's the whole meaning of two phase commit). If everything goes fine, then commit on both ends. If the DB2 database were located on a windows environment, I wouldn't be posting anything anywhere ...
It seems that no one knows (on any forum here in MSDN) how to implement 2PC in my situation.
Someone (from another forum) suggested that my problem may be solved with BizTalk ... and that is the reason why I posted my question here.
Free Windows Admin Tool Kit Click here and download it now
April 3rd, 2015 3:22am
This topic is archived. No further replies will be accepted.
Other recent topics
