470,628 Members | 2,251 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,628 developers. It's quick & easy.

two-phase commit in DB2

Is Two phase commit allowed in DB2? We need to update a local tables
and few federated tables in a single Unit of Work. Is it possible to do
?

Regards,
Ravi

Nov 1 '06 #1
5 5201
Ravi Chirawala wrote:
Is Two phase commit allowed in DB2? We need to update a local tables
and few federated tables in a single Unit of Work. Is it possible to do
?
Yes, it is.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Nov 1 '06 #2
Knut Stolze wrote:
Ravi Chirawala wrote:
>Is Two phase commit allowed in DB2? We need to update a local tables
and few federated tables in a single Unit of Work. Is it possible to do
?

Yes, it is.
.... in DB2 9 I think ...

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

WAIUG Conference
http://www.iiug.org/waiug/present/Fo...Forum2006.html
Nov 1 '06 #3
What is two phase commit and how do you go about doing this?

this is something new to me...

-Aanand

Serge Rielau wrote:
Knut Stolze wrote:
Ravi Chirawala wrote:
Is Two phase commit allowed in DB2? We need to update a local tables
and few federated tables in a single Unit of Work. Is it possible to do
?
Yes, it is.
... in DB2 9 I think ...

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

WAIUG Conference
http://www.iiug.org/waiug/present/Fo...Forum2006.html
Nov 2 '06 #4
http://en.wikipedia.org/wiki/Two-phase-commit_protocol

Larry Edelstein

fatalxception wrote:
What is two phase commit and how do you go about doing this?

this is something new to me...

-Aanand

Serge Rielau wrote:
>>Knut Stolze wrote:
>>>Ravi Chirawala wrote:
Is Two phase commit allowed in DB2? We need to update a local tables
and few federated tables in a single Unit of Work. Is it possible to do
?

Yes, it is.

... in DB2 9 I think ...

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

WAIUG Conference
http://www.iiug.org/waiug/present/Fo...Forum2006.html

Nov 2 '06 #5
Serge Rielau wrote:
Knut Stolze wrote:
>Ravi Chirawala wrote:
>>Is Two phase commit allowed in DB2? We need to update a local tables
and few federated tables in a single Unit of Work. Is it possible to do
?

Yes, it is.
... in DB2 9 I think ...
I believe you are right. Some of the F2PC functionality is already
available in V8.2, but I think that full support is enabled in V9 only.

For the usage/enablement:
In V9, you specify the server option DB2_TWO_PHASE_COMMIT and set it to 'Y'.
Then you tell the DRDA wrapper (and the DB2 engine) to use the two-phase
commit protocol when talking to the respective data source. The DB2 server
acts as transaction manager in this context.
http://publib.boulder.ibm.com/infoce...iyfqtpc03.html

Wrappers that support F2PC are:
- DRDA
- Informix
- MS SQL Server
- Oracle
- Sybase

Besides the federated piece, DB2 supports 2PC for a long time already. That
is what the connection type 2 is for.
http://publib.boulder.ibm.com/infoce...n/t0005064.htm
http://publib.boulder.ibm.com/infoce...n/c0005032.htm

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Nov 2 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by John Grenier | last post: by
7 posts views Thread by Prabhudhas Peter | last post: by
272 posts views Thread by Peter Olcott | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.