IBM Books

Quick Beginnings

What is the Syncpoint Manager?

SPM is a function that enables your distributed database applications to access multiple remote database application servers using DRDA2 protocols. The SPM guarantees the integrity of the results in SNA environments.

You need to install and use SPM if your distributed database applications will make use of the DRDA2 Distributed Unit of Work (DUOW) known as two-phase commit, and you will use SNA connections between:

For example, your application programs running at DB2 clients can issue SQL requests that result in updates to databases at multiple remote database servers, or your DB2 for OS/390 application program can issue SQL requests that result in updates to multiple remote database servers where at least one of them is a remote DB2 Universal Database server.

The LU 6.2 Syncpoint Manager is included in the following licensed programs:

Notes:

  1. SPM is not included with DB2 Connect Personal Edition (formerly DDCS Single User) or the DB2 Universal Database Personal Edition licensed programs.

  2. In order to use SPM functions, DB2 clients must be at the Version 2.1.1 code level, or higher.

  3. Application programs that will issue two-phase commit requests must be pre-compiled with the CONNECT 2 and SYNCPOINT TWOPHASE options.

  4. In DB2 Connect Enterprise Edition Version 5.0, the SPM continues to allow host databases to participate in two-phase commit transactions, but they cannot be the TM_DATABASE for such transactions.

  5. DB2 Universal Database Servers include the SPM in order to provide two-phase-commit support for DRDA-AS.

  6. If you want one workstation to act as a server for both inbound and outbound two-phase commit support, you must install both DB2 Connect Enterprise Edition and DB2 Universal Database.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]