Database support for coordinated message flows

If the message flow processing includes interaction with an external database, you can coordinate the transaction by using XA technology. XA coordination ensures that all participants update or return to a consistent state.

On distributed systems, the external coordination support is provided by WebSphere® MQ, which means that IBM® Integration Bus requires access to WebSphere MQ when processing messages. For more information about using WebSphere MQ with IBM Integration Bus, see Installing WebSphere MQ. On z/OS®, the external transaction manager is Resource Recovery Services (RRS).

The following databases provide the correct level of XA support for coordinating message flows on distributed systems:

  • IBM DB2®
  • Oracle
  • Sybase

On z/OS, database support for coordinated message flows is provided by IBM Db2 only.