Need details about 2 phase commit in db2

pingte · Active User Joined: 03 Dec 2005 Posts: 120 Location: india

I want to know details about 2 phase commit in db2. Can any one explain this to me.

What is db2 2 phase commit?
Why is it neccessary?
What are the advantages?
How does it works?

TIA

prasadvrk · Posted: Fri Jul 06, 2007 2:02 pm

As far as I know the two phase commit involves both CICS and DB2. Once CICS commits the transaction DB2 also commits the same, that's why it is called two phase commit

pingte · Active User Joined: 03 Dec 2005 Posts: 120 Location: india

Nopes.. i am asking something different....
not CICS

prasadvrk · Posted: Fri Jul 06, 2007 2:50 pm

Hope the following link has something to do with your query:
publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.admin.doc/doc/c0005032.htm

pingte · Active User Joined: 03 Dec 2005 Posts: 120 Location: india

Thanks...
but can you please explain what exactly happens.. i mean y such thing is necessary... is it solely due to resource management?

prasadvrk · Posted: Fri Jul 06, 2007 4:50 pm

Not quite!

With multisite update, also known as Distributed Unit of Work (DUOW), two phase commit (2PC), and Coordinated Distributed Transactions, an application is able to update data in multiple remote database servers with guaranteed integrity.

A typical banking transaction is a good example of a multisite update. Consider the transfer of money from one account to another in a different database server. In such a transaction it is critical that the updates that implement the debit operation on one account do not get committed unless the updates required to process the credit to the other account are committed as well. The multisite update considerations apply when data representing these accounts is managed by two different database servers

I could get this explanation from the link:
webdocs.caspur.it/ibm/udb-6.1/db2l0/duow.htm