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 IBM® MQ, which means that IBM App Connect Enterprise requires access to IBM MQ when processing messages. For more information about using IBM MQ with IBM App Connect Enterprise, see Installing IBM 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:
- DB2®
- Oracle
- Sybase
On z/OS, database support for coordinated message flows is provided by DB2 only.