Microsoft KB Archive/286765

= INFO: Two-Phase Commit Is Not Supported over TCP/IP for DB2OLEDB =

Article ID: 286765

Article Last Modified on 4/3/2004

-

APPLIES TO


 * Microsoft Host Integration Server 2000 Standard Edition

-



This article was previously published under Q286765



SUMMARY
The Microsoft OLE DB Provider for DB2 (DB2OLEDB) and Microsoft ODBC Driver for DB2 that ship with Host Integration Server 2000 do not support two-phase commit (2PC) distributed transactions over a TCP/IP network connection. Distributed transactions are only supported when connecting to DB2 by way of SNA LU 6.2.



DTC-Driven 2PC Support for DB2 for OS/390 and AS/400 Using LU 6.2
In Host Integration Server 2000, the OLE DB Provider for DB2 and ODBC Driver for DB2 are enhanced to support the DRDA Two-Phase Commit protocols over LU 6.2. This enables COM+ applications to participate in a Distributed Transaction Coordinator (DTC)-driven, two-phase commit transaction between SQL Server and DB2 databases on OS/390 and OS/400. Distributed transactions across an SNA LU 6.2 network to DB2 UDB for AIX and DB2 UDB for Windows NT are not supported.

Distributed transactions are a new feature of Microsoft Host Integration Server 2000. The provider and driver that ship with SNA Server 4.0 do not have this feature.

Working with Microsoft Transaction Server
Because Microsoft Transaction Server (MTS) uses DTC, DB2OLEDB and the Microsoft ODBC Driver for DB2 cannot be used under MTS transaction when TCP/IP connectivity is used. DB2OLEDB and the Microsoft ODBC Driver for DB2 can be used under MTS transaction when SNA LU 6.2 connectivity is used.

Additional query words: 2PC two phase HIS 2000

Keywords: kbinfo kbprovider kbdtc kb3rdparty kbdriver kbdb2 KB286765

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.