SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 08:35 AM
| |||
| |||
 Re: two-phase commit in DB2 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      |
|
02-27-2008, 08:36 AM
| |||
| |||
| Re: two-phase commit in DB2 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 |
|
02-27-2008, 08:36 AM
| |||
| |||
| Re: two-phase commit in DB2 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 |
|
02-27-2008, 08:36 AM
| |||
| |||
| Re: two-phase commit in DB2 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 > > |
|
02-27-2008, 08:36 AM
| ||||
| ||||
| Re: two-phase commit in DB2 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 |
Linear Mode
