Installation and Configuration Supplement

Host and AS/400 Multisite Update Scenarios that Require SPM

Host and AS/400 database servers require DB2 Connect to participate in a distributed transaction originating from PC, UNIX, and Web applications. In addition, many of the multisite update scenarios that involve host and AS/400 database servers require that the Syncpoint Manager (SPM) component be configured. When a DB2 instance is created, the DB2 SPM is automatically configured with default settings.

The need for SPM is dictated by the choice of protocol (SNA or TCP/IP) and use of a TP monitor. The following table provides a summary of scenarios that require the use of SPM. The table also shows that DB2 Connect is required for any access to the host or AS/400 from Intel or UNIX machines. In addition, for multisite updates, the SPM component of DB2 Connect is required if the access is via SNA or uses a TP monitor.

Table 32. Host and AS/400 multisite update scenarios that require SPM

TP Monitor Used?	Protocol	SPM Needed?	Product Required (choose One)	Host and AS/400 Database Supported
Yes	TCP/IP	Yes	DB2 Connect Enterprise Edition DB2 Universal Database Enterprise Edition DB2 Universal Database Enterprise - gExtended Edition	DB2 for OS/390 V5.1 DB2 Universal Database for OS/390 V6.1 or later
Yes	SNA	Yes	DB2 Connect Enterprise Edition* DB2 Universal Database Enterprise Edition* DB2 Universal Database Enterprise - Extended Edition* Note: *AIX, OS/2, Windows NT and Windows 2000 platforms only.	DB2 for MVS/ESA V3.1 and 4.1 DB2 for OS/390 V5.1 DB2 Universal Database for OS/390 V6.1 or later DB2/400 V3.1 or later DB2 Server for VM or VSE V5.1 or later
No	TCP/IP	No	DB2 Connect Personal Edition DB2 Connect Enterprise Edition DB2 Universal Database Enterprise Edition DB2 Universal Database Enterprise - Extended Edition	DB2 for OS/390 V5.1 DB2 Universal Database for OS/390 V6.1 or later
No	SNA	Yes	DB2 Connect Enterprise Edition* DB2 Universal Database Enterprise Edition* DB2 Universal Database Enterprise - Extended Edition* Note: *AIX, OS/2, Windows NT and Windows 2000 platforms only.	DB2 for MVS/ESA V3.1 and 4.1 DB2 for OS/390 V5.1 DB2 Universal Database for OS/390 V6.1 or later DB2/400 V3.1 or later DB2 Server for VM and VSE V5.1 or later

Note:

A distributed transaction can update any mix of supported database servers. For example, your application can update several tables in DB2 UDB on Windows NT, a DB2 for OS/390 database and a DB2/400 database all within a single transaction. For more information about two-phase commit, as well as instructions for setting up for several popular TP monitors, refer to: Administration Guide DB2 Connect Enterprise Edition for OS/2 and Windows Quick Beginnings DB2 Connect Personal Edition Quick Beginnings (this edition does not include the DB2 Syncpoint Manager). You can also access the DB2 Product and Service Technical Library on the World Wide Web: Go to the following Web page: http://www.ibm.com/software/data/db2/library/ Select the DB2 Universal Database link. Search for "Technotes" using the search keywords "DDCS", "SPM", "MTS", "CICS", and "ENCINA".