Dynamic Server supports distributed queries across multiple databases and multiple database servers for transactions that involve only built-in data types. To issue a distributed query, a client application connects to a single database server, called the local database server, and specifies a database, called the local database. By default, all the database objects that you reference come from the local database.
All other databases are external databases. All other database servers are remote database servers. A database on a remote database server is an external remote database.
When the external database is on the same database server as the local database, you must qualify the object name with the external database name (for example, salesdb:contacts). When the external database is on a remote database server, you must qualify the object name with the remote database server name and the external remote database name (salesdb@distantserver:contacts).
The database server supports two multiphase protocols, two-phase commit and heterogeneous commit, to process transactions that span multiple database servers.
For information about using distributed queries, see IBM Informix User-Defined Routines and Data Types Developer's Guide. For information about two-phase commit and heterogeneous commit protocols, see the IBM Informix Administrator's Guide. For information about a specific IBM Informix Enterprise Gateway product, see the appropriate IBM Informix Enterprise Gateway User Manual.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]