Multiphase commit protocols

A two-phase commit protocol ensures that transactions are uniformly committed or rolled back across multiple database servers. You can use HCL Informix® database servers with HCL Informix Enterprise Gateway products or transaction managers to manipulate data in non-Informix databases. Distributed queries across HCL Informix database servers support two-phase commit.

The heterogeneous commit protocol ensures that updates to one or more HCL Informix databases and one non-Informix database in a single transaction are uniformly committed or rolled back.

These topics contain information about the use of the two-phase commit protocol. For information about recovering manually from a failed two-phase commit transaction, see Manually recovering from failed two-phase commit.

These topics also contain information about using transaction support for XA-compliant, external data sources, which can participate in two-phase commit transactions. See Informix transaction support for XA-compliant, external data sources.