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

A computer program product comprising a non-transitory computer usable medium having executable code to execute a process for transparent support for distributed transactions in a clustered disk-sharing database environment, the process 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.

A system for transparent support for distributed transactions in a clustered disk-sharing database environment, comprising:

• a computer processor to execute a set of program code instructions;
• a memory to hold the program code instructions, in which the program code instructions comprises program code to:
• disassociate 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;
• send 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;
• determine whether the second resource manager has the stored transaction information for resuming the transaction;
• obtain an identity of the first resource manager using data shared by the first and the second resource managers when the second resource manager does not have the stored transaction information for resuming the transaction;
• and
• request 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.