Chapter 8. Enabling Multisite Updates (Two-Phase Commit)

This chapter provides an overview of the multisite update function as it applies to scenarios that involve host and AS/400 database servers. It describes products and components needed to implement PC, UNIX and web applications that update multiple DB2 databases in the same transaction.

Multisite update, also known as Distributed Unit of Work (DUOW) and Two-Phase commit, is a function that enables your applications to update data in multiple remote database servers with guaranteed integrity. A good example of a multisite update is a banking transaction that involves the transfer of money from one account to another in a different database server. In such a transaction it is critical that updates that implement debit operation on one account do not get committed unless updates required to process credit to the other account are committed as well. The multisite update considerations apply when data representing these accounts is managed by two different database servers.

DB2 products provide comprehensive support for multisite update. This support is available for applications developed using regular SQL as well as applications that utilize Transaction Monitor products that implement X/Open XA interface speci®cation. Examples of such Transaction Monitor products include IBM TxSeries (CICS and Encina), Message and Queuing Series, Component Broker Series, San Francisco Project as well as Microsoft Transaction Server (MTS), BEA Tuxedo, NCR TopEnd and several others. There are different setup requirements depending on whether native SQL multisite update or TP Monitor multisite update is used.

Both the native SQL and TP Monitor multisite update programs must be precompiled with the CONNECT 2 SYCNCPOINT TWOPHASE options. Both can use

the SQL Connect statement to indicate which database they want to be used for the SQL statements that follow. If there is no TP Monitor to tell DB2 it is going to coordinate the transaction (as indicated by DB2 receiving the xa_open calls from the TP monitor to establish a database connection), then the DB2 software will be used to coordinate the transaction.

When using TP monitor multisite update, the application must request commit or rollback by using the TP monitor's API, e.g. CICS SYNCPOINT, Encina Abort(), MTS SetAbort(). When using native SQL multisite update, the normal SQL COMMIT and ROLLBACK must be used.

© Copyright IBM Corp. 1993, 1999

97

Page 108 Page 110
Page 109
Image 109
IBM GC09-2830-00 manual Enabling Multisite Updates Two-Phase Commit
Page 108 Page 110

GC09-2830-00 specifications

The IBM GC09-2830-00 is a crucial technical document that details the features, technologies, and operational characteristics of the IBM Enterprise Storage System. This guide is essential for IT professionals, data engineers, and system administrators who work with IBM storage solutions.

One of the main features of the IBM GC09-2830-00 is its focus on providing a comprehensive overview of the IBM storage system's architecture. It highlights the seamless integration of various storage technologies, including the IBM Spectrum Storage Suite, which supports a range of deployment models from on-premises to hybrid cloud environments.

The document outlines the storage system's capabilities, such as high availability, which ensures that data is accessible at all times. This feature is essential for businesses that rely on continuous operation and minimal downtime. The IBM GC09-2830-00 also emphasizes the importance of scalability, allowing organizations to adjust their storage solutions as their data needs grow.

Another critical aspect covered in the GC09-2830-00 is data protection and management. The document details the robust security features inherent in the IBM storage environment, including encryption, access control, and comprehensive data backup solutions. These characteristics are vital in today’s era of rising cybersecurity threats.

In terms of performance, the document illustrates the efficient data handling capabilities of the IBM storage system. It incorporates advanced caching and tiering technologies that optimize storage resources, improving response times for applications and reducing latency.

The IBM GC09-2830-00 also discusses the user-friendly management interfaces that simplify the administration of storage resources. The integration of artificial intelligence and machine learning capabilities further enhances system management, providing predictive analytics and insights to help admins address potential issues before they impact operations.

Finally, the document emphasizes IBM's commitment to sustainability, outlining how its storage solutions minimize energy consumption and promote efficient resource usage. This characteristic aligns with the growing demand for environmentally responsible technology solutions.

In summary, the IBM GC09-2830-00 is a pivotal resource for understanding the powerful features and technologies of IBM's Enterprise Storage System, equipping users with the knowledge to leverage these tools effectively in their data management strategies.
Top Page Image Contents