Configuring XA Transaction Managers to Use DB2 UDB3

o     ${TUXDIR}/bin/buildserver -r UDB_XA -f svcfile.o -s SVC1,SVC2 -o UDBserver

Where {TUXDIR} is the directory where you installed Tuxedo.

o    For Windows NT:

o     %TUXDIR%\bin\buildserver -r UDB_XA -f svcfile.o -s SVC1,SVC2 -o UDBserver

Where %TUXDIR% is the directory where you installed Tuxedo.

7.    Set up the Tuxedo configuration file to reference the DB2 server. In the *GROUPS section of the UBBCONFIG file, add an entry similar to:

8.     UDB_GRP LMID=simp GRPNO=3

9.     TMSNAME=TMS_UDB TMSCOUNT=2

10.     OPENINFO=”UDB_XA:SAMPLE,db2_user,,db2_user_pwd”

Where the TMSNAME parameter specifies the transaction monitor server program that you built previously, and the OPENINFO parameter specifies the resource manager name. This is followed by the database name and the DB2 user and password, which are used for authentication.

The application servers that you built previously are referenced in the *SERVERS section of the Tuxedo configuration file.

11.    Start Tuxedo:

12.     tmboot -y

After the command completes, Tuxedo messages should indicate that the servers are started. In addition, if you issue the DB2 command LIST APPLICATIONS ALL, you should see two connections (in this situation, specified by the TMSCOUNT parameter in the UBD group in the Tuxedo configuration file, UBBCONFIG.

Configuring Microsoft Transaction Server

DB2 UDB V5.2 can be fully integrated with Microsoft Transaction Server (MTS) Version 2.0. Applications running under MTS on Windows 32-bit operating systems can use MTS to coordinate two-phase commit with multiple DB2 UDB, host, and AS/400 database servers, as well as with other MTS-compliant resource managers.

Enabling MTS Support in DB2

You can enable DB2 to support Microsoft Transaction Server by setting the tp_mon_name database manager configuration parameter to “MTS”. You do this on the machine where the DB2 Client Application Enabler (CAE) Version 5.2 client runs with MTS.

Use the following CLP command to enable support:

db2 update dbm cfg using tp_mon_name MTS

A sample application will be provided to verify the installation. When this sample becomes available, it will be identified on the IBM web site. Set your URL to http://www.software.ibm.com/data/db2/library and search for a DB2 Universal Database Technote with the keyword MTS.

MTS Software Prerequisites

MTS support requires the DB2 Client Application Enabler (CAE) Version 5.2, or higher, and MTS must be at Version 2.0 with Hotfix 0772.

The installation of the DB2 ODBC driver on Windows 32-bit operating systems will automatically add a new keyword into the registry:

HKEY_LOCAL_MACHINE\software\ODBC\odbcinit.ini\IBM DB2 ODBC Driver:

Keyword Value Name: CPTimeout

Data Type: REG_SZ

Value: 60

Installation and Configuration

Following is a summary of installation and configuration considerations for MTS. To use DB2’s MTS support, the user must:

1.    Install MTS on the same machine where the MTS application runs.

2.    On the same machine, install the DB2 Client Application Enabler (CAE) Version 5.2 client and set the database manager configuration parameter tp_mon_name to “MTS”.

3.    In order to use a host or AS/400 database server:

1.    Either install DB2 Connect Enterprise Edition (EE) on the same machine as MTS, or install DB2 Connect EE on a separate machine to act as a gateway to the host or AS/400 server.

2.    Configure and enable the DB2 Syncpoint Manager on the DB2 Connect EE machine.

Note:

Additional technical information may be provided on the IBM web site to assist you with installation and configuration of DB2 MTS support. Set your URL to “http://www.software.ibm.com/data/db2/library”, and search for a DB2 Universal Database “Technote” with the keyword “MTS”.

Verifying the Installation

1.    Configure DB2 Client Application Enabler (CAE) and DB2 Connect EE to access your DB2 UDB, host, or AS/400 server.

2.    Verify the connection from the DB2 CAE machine to the DB2 UDB database servers.

3.    Verify the connection from the DB2 Connect machine to your host or AS/400 database server with DB2 CLP and issue a few queries.

4.    Verify the connection from the DB2 CAE machine via the DB2 Connect gateway to your host or AS/400 database server and issue a few queries.

Supported DB2 Database Servers

     

如果这文章对你有帮助,请扫左上角微信支付-支付宝,给于打赏,以助博客运营

发表评论

您的电子邮箱地址不会被公开。 必填项已用*标注