APPLICATION RESILIENCY MANAGEMENT USING A DATABASE DRIVER

• US 20180004797A1
• Filed: 06/29/2016
• Published: 01/04/2018
• Est. Priority Date: 06/29/2016
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Ghosh, Sujan S., Joshi, Vinayak, Mathai, Shilu, Springgay, Michael R.
• Granted Patent: US 10,303,678 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 11/0751 Error or fault detection not based on redundancy power supply failures G06F1/30; network fault management H04L41/06
• CPC Class Codes: G06F 11/1474 in transactions G06F16/20 takes precedence
• CPC Class Codes: G06F 11/30 Monitoring
• CPC Class Codes: G06F 16/2308 Concurrency control transaction processing G06F9/466
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: G06F 16/242 Query formulation
• CPC Class Codes: G06F 16/2433 Query languages
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/2453 Query optimisation
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 2201/80 Database-specific techniques

Abstract

Disclosed aspects relate to using a database driver to manage application resiliency with respect to a shared pool of configurable computing resources. A transaction request having a set of command data is received. The set of command data for the transaction request is captured in a memory device coupled with the database driver. The transaction request is connected with a first asset of the shared pool of configurable computing resources. An error event is detected related to the first asset. It is ascertained that the error event indicates a configuration for an automatic client reroute (ACR) operation. Using the ACR operation, the transaction request is connected with a second asset of the shared pool of configurable computing resources. The set of command data for the transaction request is transmitted from the memory device coupled with the database driver to the second asset.

Claims

1. A computer-implemented of using a database driver to manage application resiliency with respect to a shared pool of configurable computing resources, the method comprising:

receiving, by the database driver, a transaction request having a set of command data;

capturing, in a memory device coupled with the database driver, the set of command data for the transaction request;

connecting the transaction request with a first asset of the shared pool of configurable computing resources to process the transaction request;

detecting an error event related to the first asset of the shared pool of configurable computing resources;

ascertaining that the error event indicates a configuration for an automatic client reroute (ACR) operation;

connecting, using the ACR operation, the transaction request with a second asset of the shared pool of configurable computing resources to process the transaction request; and

transmitting, from the memory device coupled with the database driver to the second asset of the shared pool of configurable computing resources to process the transaction request, the set of command data for the transaction request.

2. The method of claim 1, further comprising:

determining a successful execution of the transaction request with respect to the second asset of the shared pool of configurable computing resources; and

removing, from the memory device coupled with the database driver, the set of command data for the transaction request.

3. The method of claim 1, wherein the memory device coupled with the database driver is located at a first physical location which differs from a set of locations having the shared pool of configurable computing resources.

4. The method of claim 1, wherein the set of command data begins at a first commit-rollback data-point.

5. The method of claim 2, wherein the successful execution of the transaction request includes achievement of execution to a second commit-rollback data-point.

6. The method of claim 1, wherein the set of command data includes both a set of Structured Query Language (SQL) statements and a set of session resources.

7. The method of claim 6, wherein the set of session resources includes:

a set of special registers,

a set of client device information,

a set of global variables,

a set of global temporary tables,

a set of properties, and

a set of configurations.

8. The method of claim 1, further comprising:

receiving, in advance of capturing the set of command data for the transaction request, an indication to use the database driver to manage application resiliency.

9. The method of claim 8, wherein the indication to use the database driver to manage application resiliency is without a set of application-originated code to handle the error event.

10. The method of claim 1, wherein the transaction request includes a write request.

11. The method of claim 1, wherein the error event occurs between a first commit-rollback data-point and a second commit-rollback data-point.

12. The method of claim 1, further comprising:

detecting a failure related to the second asset of the shared pool of configurable computing resources; and

returning an error notification.

13. The method of claim 12, further comprising:

ascertaining that the failure indicates an ineligibility for the ACR operation.

14. The method of claim 1, wherein the transaction request includes a non-seamless transaction request, and wherein the set of command data includes a set of ordered Structured Query Language (SQL) data.

15. The method of claim 1, wherein the capturing, the connecting, the detecting, the ascertaining, the connecting, and the transmitting each occur without interaction with an application which sent the transaction request.

16. The method of claim 1, wherein the receiving, the capturing, the connecting, the detecting, the ascertaining, the connecting, and the transmitting each occur in an automated fashion without user intervention.

17. A system of using a database driver to manage application resiliency with respect to a shared pool of configurable computing resources, the system comprising:

a memory having a set of computer readable computer instructions, and

a processor for executing the set of computer readable instructions, the set of computer readable instructions including;

receiving, by the database driver, a transaction request having a set of command data;

capturing, in a memory device coupled with the database driver, the set of command data for the transaction request;

connecting the transaction request with a first asset of the shared pool of configurable computing resources to process the transaction request;

detecting an error event related to the first asset of the shared pool of configurable computing resources;

ascertaining that the error event indicates a configuration for an automatic client reroute (ACR) operation;

connecting, using the ACR operation, the transaction request with a second asset of the shared pool of configurable computing resources to process the transaction request; and

transmitting, from the memory device coupled with the database driver to the second asset of the shared pool of configurable computing resources to process the transaction request, the set of command data for the transaction request.

18. A computer program product of using a database driver to manage application resiliency with respect to a shared pool of configurable computing resources, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, wherein the computer readable storage medium is not a transitory signal per se, the program instructions executable by a processor to cause the processor to perform a method comprising:

receiving, by the database driver, a transaction request having a set of command data;

capturing, in a memory device coupled with the database driver, the set of command data for the transaction request;

connecting the transaction request with a first asset of the shared pool of configurable computing resources to process the transaction request;

detecting an error event related to the first asset of the shared pool of configurable computing resources;

ascertaining that the error event indicates a configuration for an automatic client reroute (ACR) operation;

connecting, using the ACR operation, the transaction request with a second asset of the shared pool of configurable computing resources to process the transaction request; and

transmitting, from the memory device coupled with the database driver to the second asset of the shared pool of configurable computing resources to process the transaction request, the set of command data for the transaction request.

19. The computer program product of claim 18, wherein the program instructions are stored in a computer readable storage medium in a data processing system, and wherein the program instructions were downloaded over a network from a remote data processing system.

20. The computer program product of claim 18, wherein the program instructions are stored in the computer readable storage medium in a server data processing system, and wherein the program instructions are downloaded over a network to the remote data processing system for use in the computer readable storage medium with the remote data processing system.