9-16 IBM Informix OnLine Database Server Administrator’s Guide
Sharing Data by Using IBM Informix STAR
Figure9-2 illustrates a situation in which data is shared over a connection
created between two different OnLine database servers.
Toexecute the example code shown in Figure 9-2, the current server process
(onitaly) contacts the france OnLine database server and requests it to
spawna database server process that can execute work on behalf of the trans-
action. Waiting to receive this request atfrance is an IBMInformix STAR
sqlexecddaemon 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 onfrance is spawned by sqlexecd, the connection
betweenthe two OnLine database servers is maintained until the database is
closed. Onesqlexecd process must be running on every OnLine database
server in the client/server environment. If your OnLine database server is
configured forIBM Informix STAR and you experience a failure, you must
restart thesqlexecd daemon when you reinitialize. (Refer to page9-23.)
Figure9-2
IBMInformix STAR
enables
OnLine to share
data across a
network.
Current OnLine
server: italy
OnLine server:
france
IBMInformix STAR
DATABASE stores5@italy
BEGIN WORK
INSERT INTO stores5@france:manufact
SELECT * FROM stores5@italy:manufact
COMMIT WORK