Ibm GC09-2830-00 Manual de usuario descargar pdf (Pagina 109)

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.

1 2 ... 104 105 106 107 108 109 110 111 112 113 114 ... 195 196

Comentarios a estos manuales

Sin comentarios

Models	Document Type
RECUMBENT RBK 800	User Manual Precor RECUMBENT RBK 800 User Manual, 100 pages
Commercial Cycles C846i	User Manual Precor Commercial Cycles C846i User Manual, 68 pages
C932	User Manual Precor C932 User Manual, 60 pages
S3.23	User Manual Precor S3.23 User Manual, 24 pages
Ellipticals EFX532i	User Manual Precor Ellipticals EFX532i User Manual, 96 pages
946l	User Manual Precor 946l User Manual, 101 pages
EFX5.21s	User Manual Precor EFX5.21s User Manual, 31 pages
EFX546i	User Manual Precor EFX546i User Manual, 114 pages
UBK 800-SERIES	User Manual Precor UBK 800-SERIES User Manual, 100 pages
ELLIPTICAL FITNESS CROSSTRAINERS EFX 835	User Manual Precor ELLIPTICAL FITNESS CROSSTRAINERS EFX 835 User Manual, 104 pages
UBK 815	User Manual Precor UBK 815 User Manual, 92 pages
LOW-IMPACT TREADMILLS 9.33	User Manual Precor LOW-IMPACT TREADMILLS 9.33 User Manual, 86 pages
UBK 800	User Manual Precor UBK 800 User Manual, 52 pages
EFX 5.21i	User Manual Precor EFX 5.21i User Manual, 58 pages
EFX 883	User Manual Precor EFX 883 User Manual, 104 pages
776i	User Manual Precor 776i User Manual, 112 pages
Commercial Stretch Trainer C240	User Manual Precor Commercial Stretch Trainer C240 User Manual, 16 pages
EFX 556i	User Manual Precor EFX 556i User Manual, 70 pages
C934	User Manual Precor C934 User Manual, 60 pages
EFX 5.25	User Manual Precor EFX 5.25 User Manual, 64 pages

Ibm GC09-2830-00 Manual de usuario Pagina 109

Comentarios a estos manuales

Precor TRM 800 manuals

Precor TRM 800 User Manual (64 pages)

Table of contents

More products and manuals for Sports and recreation Precor

Ibm GC09-2830-00 Manual de usuario Pagina 109

Comentarios a estos manuales

Relacionado con productos y manuales para Ordenadores Ibm GC09-2830-00

Precor TRM 800 manuals

Precor TRM 800 User Manual (64 pages)

Table of contents

More products and manuals for Sports and recreation Precor