IBM 000-8697 Manual De Usuario

IBM Informix OnLine Database Server Administrator’s Guide

 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

, 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 I

nformix

STAR

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 I

nformix

STAR

 and you experience a failure, you must

restart the sqlexecd daemon when you reinitialize. (Refer to

.)

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