Quick Beginnings for DB2 Connect Enterprise Edition

Using Two-Phase Commit with DB2

1. Configure the SNA Syncpoint Manager (SPM) support of DB2 Connect in the DB2 Connect machine. See Chapter 24. Configuring the DB2 Syncpoint Manager.

2. Configure the DB2 CAE client to support SPM (See the sections on "Summary of Steps for DB2 Clients Connecting to a Host" and "Summary of Steps for Remote DB2 Universal Database Servers Accessed from DRDA Hosts" in Chapter 22 of the Quick Beginnings manual for DB2 Connect EE.

3. Configure CS/NT to support the SPM.

4. Verify the two-phase commit support with a simple SQL program that is precompiled with the CONNECT 2 SYNPCOINT TWOPHASE option. See the PREP or BIND command for details. The program should simply connect to the DB2 database and perform a few SQL queries and updates.

[ DB2 List of Books | Search the DB2 Books ]