|
|
 |
 |
| iTechArt OFFERS |
|
|
|
|
|
|
|
|
|
|
| QUICK START |
|
|
|
|
|
| DEVELOPMENT SERVICES |
|
|
|
|
|
| LANGUAGES |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Oracle/DB2 integration with MTS and stress testing
The Business Reasons
This article covers typical parts of work for different customers and describes how to coordinate two-phase commit (2PC) with multiple Oracle 8i, Oracle 9i and DB2 database servers. A typical transaction scenario shows an application which interacts with only one database server in a transaction. Even though concurrent connections allow for concurrent transactions, the different transactions are not coordinated. With multisite updates, the two phases commit protocol, and coordinated distributed transactions, an application is able to update data in multiple remote database servers with guaranteed integrity. if you have an integration application that provides a single consumer over a pair of legacy databases, Oracle and DB2, you'll require two-phase commit to execute a single transaction across both back-end databases.
General goals:
- Use MTS or COM+ distributed 2PC transaction with Oracle and DB2
- Configure security
- Minimize the risk of deploying systems
- MStress testing of COM+/MTS
The Solution
Configuration and installation:
You can use COM+ and MTS components to access Oracle 8(i), Oracle 9i and DB2 database servers. They can access Oracle or BD2 database servers on Microsoft Windows NT, Windows 2000, Windows 2003, Unix, and other operating systems. There are a couple of known issues and every set of a system requirements must be carefully examined before starting an integration process. We recommend an order of installation of the software for COM+ and MTS components to work with Oracle or DB2 databases.
Processing Two-Phase Commit Transactions:
We recommend to use Microsoft Distributed Transaction Coordinator (DTC) in COM+/MTS like Transaction manager. The process begins when the client application invokes a method on the COM+ application or MTS package. COM+ (or MTS) then allocates a thread for the transaction from its user thread pool, begins the transaction, and passes the method's input parameters to the COM+ run-time environment. This thread is blocked for the transaction until the response comes back from the DBs resource managers.
DTC activates the prepare phase for the transactions, allocate a thread from its 2PC thread pool and keep it blocked until the request commit message arrives from the DBs resource managers. After all the forks of the transactions are prepared, DTC sends a commit complete message to COM+ (or MTS), and COM+ (or MTS) then sends the method's output parameters and return values back to the calling client application and releases the thread.
Transactional object for 2PC:
Compensators implement a simplified version of the DTC 2PC interfaces, prepare\notify and clean up resources in case of commit or initiate compensating action in case of abort.
Stress testing:
Results:
The solution has enabled to process Two-Phase Commit Transactions for Oracle and DB2 servers. This architecture offers broad benefits, such as enhanced scalability, security, and application logic reuse.
Technologies
- COM+/MTS
- Oracle 8i, Oracle 9i
- DB2 Universal Database
- SilkPerformer
|
|
|
|
Offshore custom software development company iTechArt - Software Development and Content Management Software development, Offshore software developers, CMS consulting: SharePoint, Ektron, Drupal and DotNetNuke
iTechArt offers first class .NET Developers, DotNetNuke consulting, Custom Software Development and Outsourcing services
Add URL:
Send an email to links@itechart.com with a description of your site and the exact URL of back link.
We'll review your site as soon as possible, and if we feel that your site provides good complimentary content, we will reciprocate the link.
Our link code: <a href="http://www.itechart.com"><strong>Software development
</strong></a> - Custom software development company iTechArt - Web site and Content Management Solutions development, CMS consulting: Sharepoint, Ektron, Drupal and DotNetNuke
|
|
Contact iTechArt about custom software development, end-to-end software solutions, outsourcing software development, custom DotNetNuke module development, DotNetNuke consulting, dotnetnuke hosting, first class Java and .Net developers, software application design,
software testing, Quality Assurance, functionality testing and defect analysis, performance and stress testing, usability testing, Microsoft Media Services and Adobe Media Flash Server solutions, digital signage solutions and custom software development, Ektron CMS400.NET developers, CMS, .NET Web Content Management software solutions, sharepoint, infopath, workflow, GNU Operating System, Linux software development and outsourcing, SharePoint 2007, WSS 3.0, MOSS 2007, Windows Workflow Foundation
|
|
|
|
© 2003-2007. :iTechArt All Rights Reserved.
|
Home
|
Software Development Directory | 2| 3| 4| 5| 6| 7| 8| 9| 10
|
Products and Services
|
SiteMap
|
|
|
|
|
|
|