Oracle/DB2 integration with MTS and stress testing
Our client is a Canadian company, which had an integration application with two legacy databases, Oracle and DB2.
Alierra Software’s main goal was to coordinate two-phase commit (2PC) with multiple Oracle 8i, Oracle 9i and DB2 database servers. With multisite updates, two phases commit protocol, and coordinated distributed transactions, an application is able to update data on multiple remote database servers with guaranteed integrity.
On the first stage of the project, Alierra Software’s specialists carefully examined all the system requirements to find out a way to perform the integration. As a result of the analysis, the software for COM+ and MTS components was installed to work with Oracle and DB2 databases. The transactional object for 2PC was created, allowing compensators to implement a simplified version of the DTC 2PC interfaces, prepare/notify and clean up resources in case of commit or initiate compensatory action in case of abort.
Stress testing showed that the solution is capable of seamless processing of Two-Phase Commit Transactions for Oracle and DB2 servers. This architecture offers broad benefits, such as enhanced scalability, security, and application logic reuse.
Tools and Technologies
- MTS & COM+ distributed 2PC transaction with Oracle and DB2
- Enhanced security
- Significant decrease of the risks of deploying systems
- MStress testing of COM+/MTS
- Oracle 8i, Oracle 9i
- DB2 Universal Database
- Efforts: 16 man/month
- Project duration: 4 months