System and method for processing transactions in a multisystem database environment

• US 20040039777A1
• Filed: 08/26/2002
• Published: 02/26/2004
• Est. Priority Date: 08/26/2002
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Schneider, Richard, Tse, Judy Y., Yuan, Jack Chiu-Chiu, Zentner, Jerome Joseph, Bridges, Thomas Phillip, Watts, Vern Lee, Bock, Steven Michael, Hannan, Richard G., Ziebarth, Mark Neal, Kuo, Steve T.
• Granted Patent: US 7,406,511 B2
• Time in Patent Office: Days
• US Class Current: 709/203
• CPC Class Codes: H04L 67/01 Protocols
• CPC Class Codes: H04L 9/40 Network security protocols
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99938 Concurrency, e.g. lock management in shared database
• CPC Class Codes: Y10S 707/99939 Privileged access

Abstract

A system for satisfying a request from a client for a send-then-commit transaction includes a front-end information management system (IMS) server. Shared message queues (SMQ) communicate with the front-end IMS server and plural back-end IMS. The front-end IMS server receives the request from the client and transmits the request to the SMQ. A back-end IMS server accesses the SMQ and generates a transaction output in response to the request. The back-end IMS server transmits the result to the front-end IMS server and the front-end IMS server interfaces with the client to communicate the response thereto. The back-end IMS server and front-end IMS server operate in separate system images, but work together in a resource recovery services (RRS) environment to commit or backout the transaction output.

Claims

1. A system for satisfying a request from a client for a send-then-commit transaction, comprising:

a front-end information management system (IMS) server;

at least one shared message queue (SMQ); and

plural back-end IMS servers connected to the front-end IMS server via the SMQ, the front-end IMS server receiving the request from the client and transmitting the request to the SMQ, at least one back-end IMS server accessing the SMQ and generating a transaction output in response to the request, the back-end IMS server transmitting the result to the front-end IMS server, the front-end IMS server interfacing with the client to communicate the response thereto, the front-end IMS server selectively causing the transaction to commit.

2. The system of claim 1, wherein the front-end IMS server causes the transaction to commit upon successful interfacing with the client to communicate the response thereto, otherwise the front-end IMS server causing the transaction to be backed out.

3. The system of claim 1, further comprising:

a cross-system coupling facility (XCF) connected to the front-end IMS server and the back-end IMS servers.

4. The system of claim 3, wherein the transaction output is transmitted to the front-end IMS server via the XCF.

5. The system of claim 3, wherein the transaction output is transmitted to the front-end IMS server via the SMQ.

6. The system of claim 4, wherein the transaction is non-conversational and the transaction output is less than sixty-one kilobytes (61 k).

7. The system of claim 5, wherein the transaction is conversational.

8. The system of claim 5, wherein the transaction is non-conversational and the transaction output is greater than sixty-one kilobytes (61 k).

9. A method for satisfying a request from a client for a send-then-commit transaction, comprising the acts of:

receiving the request at least one front-end IMS servers;

transmitting the request to at least one SMQ;

accessing the SMQ with multiple back-end IMS servers;

processing the request with at least one of the back-end IMS servers to generate a transaction output;

sending the transaction output to the front-end IMS server;

attempting to successfully interface with the client using the front-end IMS server to communicate the transaction output to the client; and

committing the transaction output if the attempting act is successful.

10. The method of claim 9, further comprising the act of:

backing out the transaction output if the attempting act is unsuccessful.

11. The method of claim 10, further comprising the act of:

transmitting the transaction output to the front-end IMS server via the SMQ.

12. The method of claim 10, further comprising the act of:

transmitting the transaction output to the front-end IMS server via an XCF.

13. The method of claim 11, wherein the transaction is conversational.

14. The method of claim 11, wherein the transaction is non-conversational and the transaction output is greater than sixty-one kilobytes (61 k).

15. The method of claim 12, wherein the transaction is non-conversational and the transaction output is less than sixty-one kilobytes (61 k).

16. A computer program device, comprising:

a computer readable means having logic means for satisfying a send-then-commit transaction request between a client and a front-end IMS server, comprising;

logic means for receiving the request at least one front-end IMS servers;

logic means for transmitting the request to at least one SMQ;

logic means for accessing the SMQ with multiple back-end IMS servers;

logic means for processing the request with at least one of the back-end IMS servers to generate a transaction output;

logic means for sending the transaction output to the front-end IMS server;

logic means for attempting to successfully interface with the client using the front-end IMS server to communicate the transaction output to the client; and

logic means for committing the transaction output if the attempting act is successful.

17. The computer program device of claim 16, further comprising:

logic means for backing out the transaction output if the attempting act is unsuccessful.

18. The computer program device of claim 17, further comprising:

logic means for transmitting the transaction output to the front-end IMS server via the SMQ.

19. The computer program device of claim 17, further comprising:

logic means for transmitting the transaction output to the front-end IMS server via an XCF.

20. The computer program device of claim 18, wherein the transaction is conversational.

21. The computer program device of claim 18, wherein the transaction is non-conversational and the transaction output is greater than sixty-one kilobytes (61 k).

22. The computer program device of claim 19, wherein the transaction is non-conversational and the transaction output is less than sixty-one kilobytes (61 k).