IBM 000-8697 Manuel D’Utilisation
![IBM](https://files.manualsbrain.com/attachments/f70d337d03c66895b7a6fbe0e6de3554f47d7dd3/common/fit/150/50/fb4e568062ca4d0154259807170f4c71f2c7aafa861a4d9a0eb3af958af4/brand_logo.png)
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