IBM 000-8697 User Manual
Product Environment
9-15
OnLine Administration with IBM Informix STAR
OnLine Administration with IBM Informix STAR
The
IBM I
nformix
STAR
product enables a user to query and update more
than one database across multiple OnLine database servers within a single
transaction. The OnLine database servers can reside within a single host
machine or on the same network.
transaction. The OnLine database servers can reside within a single host
machine or on the same network.
The information in this manual describes topics of concern to the adminis-
trator whose database server uses
trator whose database server uses
IBM I
nformix
STAR
to share data with other
OnLine database servers.
(
IBM I
nformix
STAR
installation and configuration issues are addressed in the
IBM I
nformix
NET
and
IBM I
nformix
STAR I
nstallation and
C
onfiguration
G
uide.)
For background information about networks and distributed data, refer to
IBM I
nformix
G
uide to
SQL: T
utorial. For detailed information about the correct
SQL
syntax for specifying databases located on other OnLine database
servers, refer to specific
SQL
statement descriptions in
IBM I
nformix
G
uide to
SQL: R
eference.
Sharing Data by Using IBM Informix STAR
If your OnLine database server is configured with
IBM I
nformix
STAR
, the
following situations can occur during processing:
■
The current database might reside on another OnLine database
server.
server.
■
A query or update can refer to tables that are located in one or more
databases that reside on other OnLine database servers.
databases that reside on other OnLine database servers.