Transparent support for distributed transactions in a clustered disk-sharing database environment

摘要

A method, system and computer program product for transparent support for distributed transactions in a clustered disk-sharing database environment is disclosed. In one approach, a method, a system and a computer program product are disclosed that disassociate a transaction with a session at a first resource manger, send a request to a second resource manager for the transaction that requires access to stored transaction information from prior requests for the transaction, determine whether the second resource manager has access to transaction information for the transaction stored using the session that has been disassociated with the transaction, obtain an identity of the first resource manager in data shared by the first and the second resource managers, and request access to the transaction information at the first resource manager.

主权项

1. A method for transparent support for distributed transactions in a clustered disk-sharing database environment, comprising:
disassociating a transaction with a session at a first resource manager before the transaction completes, wherein transaction information for resuming the transaction is stored at the first resource manager; sending a request to a second resource manager for resuming the transaction, wherein resuming the transaction requires access by the second resource manager to the stored transaction information and wherein the request for resuming the transaction is sent to the second resource manager for load balancing the clustered disk-sharing database environment; determining whether the second resource manager has the stored transaction information for resuming the transaction; obtaining an identity of the first resource manager using data shared by the first and second resource managers when the second resource manager does not have the stored transaction information for resuming the transaction; and requesting access to the transaction information stored at the first resource manager using the identity of the first resource manager when the second resource manager does not have the stored transaction information, wherein the transaction information stored at the first resource manager is accessed after the transaction has been disassociated with the session at the first resource manager and wherein the transaction information stored at the first resource manager is used by the second resource manager to resume the transaction.