Installation and Configuration Supplement

Configuration Steps for DB2 Universal Database Server

This section describes the steps and conditions required to configure a DB2 Universal Database server to accept inbound client requests from host and AS/400 database clients.

Before you begin, you must determine whether your connection will use the APPC communication protocol, or the TCP/IP communication protocol, or both.

Platform

Supported Protocols

AIX

TCP/IP, APPC, APPC Multisite Update

Linux

TCP/IP

PTX

TCP/IP

Solaris

TCP/IP, APPC

OS/2

TCP/IP, APPC, APPC Multisite Update

Windows NT and Windows 2000

TCP/IP, APPC, APPC Multisite Update

Notes:

1. The protocol you choose may depend on the host or AS/400 database client version:
   • APPC is supported by all host or AS/400 database client versions
   • TCP/IP is supported on the following host or AS/400 database client versions
     • DB2 for OS/390 Version 5 or higher
     • DB2 for AS/400 Version 4 Release 2 or higher
     • DB2 for VM Version 6 or higher.

2. Considerations for Multisite Update (Two Phase Commit)

   If your host or AS/400 application required Multisite Update support (two-phase commit), you should note the following:

   APPC Connections (SNA)

   DB2 Universal Database Enterprise Edition for OS/2, AIX, and Windows NT and DB2 Extended Enterprise Edition for AIX, and Windows NT provide support for SNA two phase commit with host and AS/400 database clients. The supported SNA stacks for use with multisite update are:

   • IBM eNetwork Communications Server for AIX Version 5.0.3
   • IBM eNetwork Communications Server for Windows NT Version 5.01
   • IBM eNetwork Communications Server for OS/2 Version 5
   • Microsoft SNA Server Version 4 Service Pack 3

   TCP/IP Connections

   Multisite Update is not supported with any host or AS/400 database clients. Remote Unit of Work (RUW) is supported (one phase commit)

3. To use APPC on AIX, the optional communication support component for SNA (db2_06_01.cs.sna) must also be installed.

4. To use APPC on Solaris, the optional communication support component for SNA (db2cssna) must also be installed.

Configuring DB2 Universal Database Servers for Host or AS/400 Client Access

This section gives an overview of the steps necessary to configure DB2 Universal Database to accept inbound requests from host or AS/400 database clients. The example shows how to configure a connection from a DB2 for MVS/ESA or DB2 Universal Database for OS/390 client to a DB2 Universal Database server:

1. Ensure DB2 for MVS/ESA or DB2 Universal Database for OS/390 is installed and operational on the host.

   Refer to the Connectivity Supplement for information on the configuration required for the DB2 for MVS/ESA or DB2 Universal Database for OS/390 AR.

2. If you use APPC, ensure VTAM is installed and operational on the host.
3. Update the tables at the DB2 for MVS/ESA or DB2 for OS/390 host.

   Refer to the Connectivity Supplement for more information.

4. Set up the DB2 Universal Database server communications, if required. (Typically, DB2 UDB server communications are set up as part of the DB2 UDB installation. However, complete details are provided in Using the Command Line Processor to Configure Server Communications. If you want to use Multisite Update, see Enabling Multisite Updates (Two-Phase Commit).)
5. Test the connection by logging onto TSO and using DB2I/SPUFI.