Filter
Top Products
9-16 IBM Informix OnLine Database Server Administrator’s Guide
Sharing Data by Using IBM Informix STAR
Figure 9-2 illustrates a situation in which data is shared over a connection
created between two different OnLine database servers.
To execute the example code shown in Figure 9-2, the current server process
(on italy) contacts the france OnLine database server and requests it to
spawn a database server process that can execute work on behalf of the trans-
action. Waiting to receive this request at france is an IBM Informix STAR
sqlexecd daemon process. The task of the sqlexecd daemon process is to wait
for requests that arrive over the network and spawn database server
processes that perform work on behalf of the requesting processes. After a
database server process on france is spawned by sqlexecd, the connection
between the two OnLine database servers is maintained until the database is
closed. One sqlexecd process must be running on every OnLine database
server in the client/server environment. If your OnLine database server is
configured for IBM Informix STAR and you experience a failure, you must
restart the sqlexecd daemon when you reinitialize. (Refer to page 9-23.)
Figure 9-2
IBM Informix STAR
enables
OnLine to share
data across a
network.
Current OnLine
server: italy
OnLine server:
france
IBM Informix STAR
DATABASE stores5@italy
BEGIN WORK
INSERT INTO stores5@france:manufact
SELECT * FROM stores5@italy:manufact
COMMIT WORK