The database server allows users to query and update more than one database across multiple database servers. This type of query is called a distributed query. The database servers can reside on a single host computer, on the same network, or on a gateway.
For more information on distributed queries, see the IBM Informix Database Design and Implementation Guide and IBM Informix Guide to SQL: Tutorial.
A global transaction is a transaction that involves more than one database server. IBM Informix database servers support two types of global transactions:
Informix uses a two-phase commit protocol to ensure that distributed queries are uniformly committed or rolled back across multiple database servers. For more information, see Multiphase Commit Protocols.
Transaction managers manage terminals and data recovery. The TP/XA library enables communication between a third-party transaction manager and IBM Informix databases in an X/Open environment. For more information, see the IBM Informix TP/XA Programmer's Manual and Transaction Managers.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]