TP Monitor multisite update can coordinate a transaction that accesses both DB2 and non-DB2 resource managers such as Oracle, Informix, SQLServer, etc. Native SQL multisite update is used with DB2 servers only.

For a multisite update transaction to work, each of the databases participating in a distributed transaction must be capable of supporting Distributed Unit of Work. At the time of this writing, the following DB2 servers provided DUOW support that enabled them to participate in distributed transactions:

vDB2 Common Server V2

vDB2 Universal Database V5 and V6

vDB2 for MVS/ESA V3.1 and 4.1

vDB2 for OS/390 V5.1

vDB2 Universal Database for OS/390 V6.1

vDB2/400 V3.1 or later (using SNA only at this time)

vDB2 Server for VM and VSE V5.1 and 6.1

A distributed transaction can update any mix of supported database servers. For example, your application can update several tables in DB2 Universal Database on Windows NT, a DB2 for OS/390 database and a DB2/400 database all within a single transaction.

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 con®gured. The need for SPM is dictated by the choice of protocol (SNA vs. TCP/IP) and use of a TP monitor. See the following table for a summary of scenarios that require use of the SPM. The table 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.

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

98Quick Beginnings

Page 110
Image 110
IBM GC09-2830-00 manual Host and AS/400 multisite update scenarios that require SPM

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.