Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


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:

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:

Short for
eXtended Architecture
An X/Open standard for distributed transaction handling. For more information, visit:
Microsoft Distributed Transaction Coordinator
The transaction manager used in Windows environments. DTC is supported in Windows 95/98/NT/2000. For more information, visit: http://msdn.microsoft.com/library
Application Server
A program that handles all application operations between users and an organization's business applications or databases.
Microsoft Transaction Server
The Microsoft application server
Enterprise JavaBeans
The framework for application servers in the Java environment.


A Transaction Manager (TM) must be present in the distributed transaction system. The TM handles the 2-phase commit protocol between all the parties involved in the transaction.

Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
Mimer SQL Documentation TOC PREV NEXT INDEX