Advanced fine-grained administration of recovering transactions

• US 20070043784A1
• Filed: 08/16/2005
• Published: 02/22/2007
• Est. Priority Date: 08/16/2005
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Parkinson, Paul
• Granted Patent: US 7,698,309 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

A method, system, and computer program product provides advanced and fine-grained transaction administration features, along with interoperability between transactional software architectures and business entities. A method of administering recovering transactions comprises the steps of operating a transaction processing system, and attempting recovery of a plurality of transactions in the transaction processing system after a failure of the transaction processing system by determining a recovery action to be taken for each of the plurality of transactions individually.

Claims

1. A method of administering recovering transactions comprising the steps of:

operating a transaction processing system; and

attempting recovery of a plurality of transactions in the transaction processing system after a failure of the transaction processing system by determining a recovery action to be taken for each of the plurality of transactions individually.

2. The method of claim 1, wherein the attempting step comprises the steps of:

for each of the plurality of transactions;

determining a state of the transaction; and

determining an administrative action to be taken with the transaction based on the state of the transaction and on resources enlisted in the transaction.

3. The method of claim 2, wherein the step of determining an administrative action comprises the steps of:

rolling back the transaction, if the state of the transaction is active and the resources enlisted in the transaction are of a certain type;

completing the transaction, if the state of the transaction is in-doubt and the resources enlisted in the transaction are of a certain type; and

abandoning the transaction, if the state of the transaction is recovering and the resources enlisted in the transaction are of a certain type.

4. The method of claim 3, wherein an active transaction is a transaction which has not yet entered a preparing phase of a commit process and the limit includes the transaction taking longer than a predefined response time, relative to desired system response time, or the transaction using resources greater than a predefined system resource allocation.

5. The method of claim 3, wherein an in-doubt transaction is a transaction which is in a preparing phase of a commit process, and which has not yet entered a commit and the limit includes the transaction taking longer than a predefined response time, relative to desired system response time, or the transaction using resources greater than a predefined system resource allocation.

6. The method of claim 3, wherein a recovering transaction is a transaction which has suffered an error or failure, and which the system is attempting to repair and complete and the limit includes the transaction taking longer than a predefined response time, relative to desired system response time, or the transaction using resources greater than a predefined system resource allocation.

7. A system for administering recovering transactions comprising:

a processor operable to execute computer program instructions;

a memory operable to store computer program instructions executable by the processor; and

computer program instructions stored in the memory and executable to perform the steps of;

operating a transaction processing system; and

attempting recovery of a plurality of transactions in the transaction processing system after a failure of the transaction processing system by determining a recovery action to be taken for each of the plurality of transactions individually.

8. The system of claim 7, wherein the attempting step comprises the steps of:

for each of the plurality of transactions;

determining a state of the transaction; and

determining an administrative action to be taken with the transaction based on the state of the transaction and on resources enlisted in the transaction.

9. The system of claim 8, wherein the step of determining an administrative action comprises the steps of:

rolling back the transaction, if the state of the transaction is active and the resources enlisted in the transaction are of a certain type;

completing the transaction, if the state of the transaction is in-doubt and the resources enlisted in the transaction are of a certain type; and

abandoning the transaction, if the state of the transaction is recovering and the resources enlisted in the transaction are of a certain type.

10. The system of claim 9, wherein an active transaction is a transaction which has not yet entered a preparing phase of a commit process and the limit includes the transaction taking longer than a predefined response time, relative to desired system response time, or the transaction using resources greater than a predefined system resource allocation.

11. The system of claim 9, wherein an in-doubt transaction is a transaction which is in a preparing phase of a commit process, and which has not yet entered a commit and the limit includes the transaction taking longer than a predefined response time, relative to desired system response time, or the transaction using resources greater than a predefined system resource allocation.

12. The system of claim 9, wherein a recovering transaction is a transaction which has suffered an error or failure, and which the system is attempting to repair and complete and the limit includes the transaction taking longer than a predefined response time, relative to desired system response time, or the transaction using resources greater than a predefined system resource allocation.

13. A computer program product for administering recovering transactions comprising:

a computer readable medium;

computer program instructions, recorded on the computer readable medium, executable by a processor, for performing the steps of

operating a transaction processing system; and

attempting recovery of a plurality of transactions in the transaction processing system after a failure of the transaction processing system by determining a recovery action to be taken for each of the plurality of transactions individually.

14. The computer program product of claim 13, wherein the attempting step comprises the steps of:

for each of the plurality of transactions;

determining a state of the transaction; and

determining an administrative action to be taken with the transaction based on the state of the transaction and on resources enlisted in the transaction.

15. The computer program product of claim 14, wherein the step of determining an administrative action comprises the steps of:

rolling back the transaction, if the state of the transaction is active and the resources enlisted in the transaction are of a certain type;

completing the transaction, if the state of the transaction is in-doubt and the resources enlisted in the transaction are of a certain type; and

abandoning the transaction, if the state of the transaction is recovering and the resources enlisted in the transaction are of a certain type.

16. The computer program product of claim 15, wherein an active transaction is a transaction which has not yet entered a preparing phase of a commit process and the limit includes the transaction taking longer than a predefined response time, relative to desired system response time, or the transaction using resources greater than a predefined system resource allocation.

17. The computer program product of claim 15, wherein an in-doubt transaction is a transaction which is in a preparing phase of a commit process, and which has not yet entered a commit and the limit includes the transaction taking longer than a predefined response time, relative to desired system response time, or the transaction using resources greater than a predefined system resource allocation.

18. The computer program product of claim 15, wherein a recovering transaction is a transaction which has suffered an error or failure, and which the system is attempting to repair and complete and the limit includes the transaction taking longer than a predefined response time, relative to desired system response time, or the transaction using resources greater than a predefined system resource allocation.

19. A transaction processing system comprising:

a transaction manager operable to perform transaction processing; and

a recovery manager operable to attempt recovery of a plurality of transactions in the transaction processing system after a failure of the transaction processing system by determining a recovery action to be taken for each of the plurality of transactions individually.

20. The system of claim 19, wherein the recovery manager is further operable to attempt recovery by, for each of the plurality of transactions, determining a state of the transaction, and determining an administrative action to be taken with the transaction based on the state of the transaction and on resources enlisted in the transaction.

21. The system of claim 20, wherein the recovery manager is further operable to determine an administrative action by rolling back the transaction, if the state of the transaction is active and the resources enlisted in the transaction are of a certain type, completing the transaction, if the state of the transaction is in-doubt and the resources enlisted in the transaction are of a certain type, and abandoning the transaction, if the state of the transaction is recovering and the resources enlisted in the transaction are of a certain type.

22. The system of claim 22, wherein an active transaction is a transaction which has not yet entered a preparing phase of a commit process and the limit includes the transaction taking longer than a predefined response time, relative to desired system response time, or the transaction using resources greater than a predefined system resource allocation.

23. The system of claim 22, wherein an in-doubt transaction is a transaction which is in a preparing phase of a commit process, and which has not yet entered a commit and the limit includes the transaction taking longer than a predefined response time, relative to desired system response time, or the transaction using resources greater than a predefined system resource allocation.

24. The system of claim 22, wherein a recovering transaction is a transaction which has suffered an error or failure, and which the system is attempting to repair and complete and the limit includes the transaction taking longer than a predefined response time, relative to desired system response time, or the transaction using resources greater than a predefined system resource allocation.