If you want the database that you access through a JDBC type 4 connection to participate in globally coordinated transactions, set up the appropriate environment.
On distributed systems, a WebSphere® MQ queue manager associated with the integration node performs the transaction manager role, 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.
Updates that you make to a database across a JDBC type 4 connection can be coordinated with other actions taken within the message flow, if you set up the resources to support coordination.
Complete the following steps:
If you have been following the instructions in Working with databases, the next task is Configuring ODBC connections for globally coordinated transactions (optional).