Distributed Transactions

Mimer SQL supports distributed transactions based on the XA interface as defined by Open Group and Microsoft's Distributed Transaction Coordinator (DTC) protocol.

This means that Mimer SQL can participate with other XA and DTC enabled systems to process transactions over different platforms and between databases from different vendors.

Mimer SQL can:

Log-in transaction managers

Associate a connection with a specific transaction

Perform operations on behalf of transactions

Validate transactions and secure them to disk

Rollback transactions

Commit transactions

Release transaction resources

Recover transactions

Note: Support for distributed transactions is not included in the standard Mimer SQL distribution. In order to implement distributed transactions, you must have the correct type of license. Contact Upright Database Technology AB for more information.

Terms and Abbreviations

In the field of distributed transactions, a number of terms and abbreviations are used. Here are the most common ones: