This topic describes the configuration steps necessary to use IBM
Power Systems and
System z
database servers within your TP monitor. These steps are not required if you are using
the IBM data server package through Db2 Connect client. For details,
see the topic about IBM data server client
types.
Before you begin
You must have an operational TP monitor and have Db2 Connect installed, as well
as have configured and tested a connection to the IBM mainframe database server.
Procedure
To configure Db2 Connect to use IBM
Power Systems and
System z
database servers within your TP monitor, perform the following steps:
-
Configure the TP monitor so that it can access the Db2® XA Switch. The
Db2 XA Switch
provides the TP monitor with the addresses of Db2 Connect's XA APIs.
Every TP monitor has a different way to do this.
-
Configure the TP monitor with the XA_OPEN string of Db2 product. Each TP
monitor has its own way to do this. For information about how to configure XA OPEN string of the
Db2 product, for
use by the TP monitor, refer to your TP monitor's documentation.
-
If required, modify the Db2 Connect sync point manager
(SPM) default configuration parameters. IBM
host and System i (Version 5 Release 3 and earlier)
database servers do not yet support the XA interface. System
i Version 5 Release 4 and following has full XA support.
The SPM is a component of Db2 Connect which maps the XA
two phase commit protocol into the two phase commit protocol used by IBM mainframe database servers. By default, the Db2 instance has
predefined values for the SPM configuration parameters. The most significant parameter is the
database manager configuration parameter spm_name. It defaults to a variant of
the first seven characters of the TCP/IP hostname.
-
On Db2,
set the DB2COMM registry variable to use TCPIP, and set the
svcename database manager configuration parameter to a TCP/IP port number or
service name.