Data source requirements and configuration for federated two-phase commit transactions

Before enabling federated two-phase commit for a data source, you must ensure it is a supported data source.

Federated systems support two-phase commit operations with the following data sources:

  • Db2® family data sources through the Distributed Relational Database Architecture™ (DRDA) protocol:
    • Db2 version 8.1 or later
    • Db2 for z/OS® version 7.1 or later
    • Db2 for IBM® i version 5.3 or later
  • Informix® IDS, version 7.31 or later, version 9.40 or later, version 10.0 or later
  • Informix XPS, version 8.40 or later
  • Microsoft SQL Server 2000 and Microsoft SQL Server 2005 for a federated server only on Windows
  • Oracle, version 8.1.7 or later, with the XA library
  • Sybase Adaptive Server Enterprise, version 12 or later, with the XA library for a federated server only on Windows

If you attempt to enable federated two-phase commit for an unsupported data source, you receive an SQL1881N error.