two-phase commit in DB2

[Ravi Chirawala]

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

[Knut Stolze]

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

[Serge Rielau]

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

[fatalxception]

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

[Larry]

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

[Knut Stolze]

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