Product Environment 9-17
Sharing Data by Using IBM Informix STAR
Updating Multiple OnLine Servers
IBMInformix STAR ensures that transactions that span more than one OnLine
database server meet all the requirements of transaction processing
(atomicity, consistency, isolation, and durability). Consider the single trans-
action(illustrated in Figure 9-3) in which one update and two inserts occur at
three different OnLine database servers:
Figure9-3
IBMInformix STAR
enables
multiserverupdates
across a network.
Current OnLine server:
italy
OnLine server:
france
OnLine server:
australia
IBMInformix STAR
DATABASE stores5@italy
BEGIN WORK
UPDATE stores5:manufact
SET manu_code = "SHM"
WHERE manu_name = "Shimara"
INSERT INTO stores5@france:manufact
VALUES ("SHM", "Shimara", "30")
INSERT INTO stores5@australia:manufact
VALUES ("SHM", "Shimara", "30")
COMMIT WORK