IBM 000-8697 User Manual
Product Environment
9-17
Sharing Data by Using IBM Informix STAR
Updating Multiple OnLine Servers
IBM I
nformix
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
(atomicity, consistency, isolation, and durability). Consider the single trans-
action (illustrated in
) in which one update and two inserts occur at
three different OnLine database servers:
Figure 9-3
IBM Informix STAR
enables
multiserver updates
across a network.
Current OnLine server:
italy
OnLine server:
france
OnLine server:
australia
IBM Informix STAR
DATABASE stores5@italy
BEGIN WORK
UPDATE stores5:manufact
BEGIN WORK
UPDATE stores5:manufact
SET manu_code = "SHM"
WHERE manu_name = "Shimara"
WHERE manu_name = "Shimara"
INSERT INTO stores5@france:manufact
VALUES ("SHM", "Shimara", "30")
INSERT INTO stores5@australia:manufact
VALUES ("SHM", "Shimara", "30")
COMMIT WORK