Home | Previous Page | Next Page   Managing Databases > Using Distributed Queries > Overview of Distributed Queries >

Coordinator and Participant in a Distributed Query

To allow cross-server distributed query ability, IBM Informix servers maintain hierarchical relationships consisting of a coordinator and one or more participants. Coordinator and participant are defined as follows:

The following examples refer to a multi-server environment where db is the local database, db2 is an external database residing on the same server, and master_db is an external database on the remote server new_york.

The following examples shows a query that could be used to access data on another server using database db as the coordinator.

database db; select col1, col2 from db2:tab1, master_db@newyork:tab2;

A session will have only one local database, but can open multiple external databases. Distributed queries must always originate on a coordinator.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]