HOWTO: Upgrading MTS 2.0 DTC to Support IBM DB2 and Informix Databases

ID: Q192681

The information in this article applies to:

Microsoft Transaction Server 2.0

SUMMARY

Microsoft Distributed Transaction Coordinator(MS DTC) has been enhanced to support IBM DB2 and Informix databases. The enhanced version of MS DTC permits a Microsoft Transaction Server application to access IBM DB2 and Informix databases on Windows NT and many other platforms under distributed transaction control.

MORE INFORMATION

IBM DB2 Support

IBM has enhanced its DB2 ODBC driver to work with Microsoft Transaction Server. IBM's new DB2 driver fully supports Microsoft Transaction Server including connection pooling and automatic transaction enlistment. It allows Microsoft Transaction Server applications to update IBM DB2 databases on Windows NT, OS/2, AIX, HP/UX, Solaris, AS/400, MVS, OS/390, VM, and VSE platforms. All updates can be performed under distributed transaction protection. This allows updates to IBM DB2 databases to be synchronized with updates to other transaction protected resources including Microsoft SQL Server, Microsoft Message Queue Server, Oracle databases, Informix databases, and the like.

The following IBM platforms are supported:

DB2 UDB Version 5 on Windows NT, OS/2, AIX, HP/UX, and Solaris

A transactional Microsoft Transaction Server application on Windows NT can connect to an IBM DB2 database on these platforms over TCP/IP, SNA, NetBIOS (Windows NT and OS/2 only), or SPX/IPX (Windows NT, OS/2, and AIX only).

AS/400, MVS, VM, OS/390, VM and VSE through DRDA

A transactional Microsoft Transaction Server application on Windows NT that needs to connect to an IBM DB2 database on AS/400, MVS, OS/390, VM, and VSE must use DB2 Connect Enterprise Edition V5 (DB2 Connect EE) and the IBM Communication Server on Windows NT, OS/2, or AIX.

In a future release, IBM plans to make it possible for a Microsoft Transaction Server application running on Windows NT to connect directly to an AS/400 or MVS system over TCP/IP.

Customers need to apply DB2's March 98 FixPak 3 to the DB2 client (DB2 CAE V5 or DB2 SDK V5) and the DB2 server (DB2 UDB V5 or DB2 Connect V5). The FixPak can be downloaded from the DB2 Service Maintenance Web site at

http://www.software.ibm.com/data/db2/db2tech/indexsvc.html

NOTE: The preceding URL is not under the control of Microsoft and we make no warranty regarding its use.

Informix Support

Informix has enhanced its Informix ODBC driver to work with Microsoft Transaction Server. This new driver fully supports Microsoft Transaction Server including connection pooling and automatic transaction enlistment. It allows Microsoft Transaction Server applications to update Informix databases on Windows NT and a variety of UNIX platforms. This allows updates to Informix databases to be synchronized with updates to other transaction protected resources including Microsoft SQL Server, Microsoft Message Queue Server, Oracle databases, IBM DB2 databases, and the like.

Where to Get This Release

This update is available for download on the Microsoft anonymous ftp server:

ftp://ftp.microsoft.com/bussys/distapps/MTS/Public-Fixes/usa/DTC/

Who Should Install This Release?

You must install this update if you need to access IBM DB2 or Informix databases from MTS components under the protection of MS DTC distributed transactions.

This update can only be applied to systems running MTS 2.0. That is the version of Microsoft Transaction Server that was distributed as part of the NT 4.0 Option Pack release. If you have not yet installed MTS 2.0, you can obtain it from the Microsoft Web site by clicking the Resources link on http://www.microsoft.com/com/.

If you only access Microsoft SQL Server, Oracle, and Microsoft Message Queue Server, you do not need to install this release.

The changes included in this update will also be included in the Windows NT 4.0 Service Pack 4 release. When Service Pack 4 is available, you can install it rather than installing this update.

Procedure to Apply the Update

Create an empty temporary directory on your system.

Run the self-extracting executable file and type the name of the temporary directory when prompted to do so. The program will unzip the following files into the temporary directory.
Adme.dll
Dtccm.dll
Dtcxatm.dll
Enudtc.dll
Msdtcprx.dll
Readme.txt
Xolehlp.dll

Ensure that the Microsoft DTC service is stopped. Ensure that any services which depend upon MS DTC are also stopped including Microsoft Transaction Server, Microsoft SQL Server, Microsoft Message Queue Server, and Microsoft COM Transaction Integrator (COMTI). Ensure that the Windows NT Control Panel is not active.

The DLLs that you must replace are all located in the Winnt40\System32 directory. You should first rename the six existing DLLs so that you can return to them later, if you need to do so.

Copy the DLL files listed above to the Winnt40\System32 directory.

Register the Adme.dll and Msdtcprx.dll files by running the following commands from the Winnt\system32 directory at a command prompt:
```
     regsvr32.exe adme.dll
     regsvr32.exe msdtcprx.dll 
```

Restart the MS DTC service and any other services that depend upon it.

Install the appropriate IBM DB2 or Informix software release.

Additional query words: prodtranssrv

Keywords : kbDTC kbMTS kbMTS200 kbGrpCom kbDSupport
Version : winnt:2.0
Platform : winnt
Issue type : kbhowto