International Business Machines Corporation

Harry Otto Radke

Curt Lee Cotner

Steve T Kuo

Thomas Clarke Morrison

Brian Keith Howell

Richard A Crus

Robert Daniel Millar

Robert Shiwen Lai

Hoang Minh Nguyen

A method and system for efficiently providing maintenance activity on a relational database that is utilized within a processing system is disclosed. The relational database includes a pool of threads and a plurality of resources. The pool of threads receive requests from a plurality of clients and control the plurality of resources. The method and system comprise determining that a maintenance activity is required and providing a first command that initiates a first process which terminates all threads in the pool of threads if the maintenance activity is required. The method and system further include providing a second command which initiates a second process after the maintenance activity has completed which causes the threads to be created and initiates the processing of requests. A system and method in accordance with the present invention based upon the determination that a maintenance activity is required causes the pool threads within a relational database to terminate and thus free up resources but also allows the connections from the clients to persist. Once the relational database resources are freed, the maintenance activity is performed, and thereafter distributed relational database processing is resumed.

Method and system for efficiently providing maintenance activity on a relational database that is utilized within a processing system

In a transaction processing system that includes a plurality of client processes coupled to a server process, the server process supports execution of transactions generated by the client processes. The server process includes, for each client process being served, one or more transaction message control mechanisms. Each transaction message control mechanism includes a named processing object that includes a name identifying the object. The named processing object also includes an input process that receives all transaction request messages naming the object and identifying the originating client process. The input process dispatches a transaction process for each transaction request message received from the respective client process. Each transaction process oversees transaction execution and receives transaction output. A transaction process provides a transaction output message for the originating client process. In a non-sync'd mode of operation, transaction processes may synchronously send transaction output messages to client processes. In a synchronized mode of operation, one transaction process at a time sends output messages under control of an output process in the named processing object. The transaction message control mechanisms provide a bi-directional transaction message flow between server and client processes.

Apparatus and method enabling a client to control transaction message traffic between server and client processes

A transaction processing system, adapted for use in a computer system having a host computer running applications and user terminals connected to the host computer, determines the transaction attributes for each transaction received by the host computer and dynamically associates a transaction protocol to be used in processing that particular transaction. The transaction protocol specifies such attributes as synchronization paradigm and flow control. The synchronization paradigm and flow control are used only for as long as the transaction remains in the system and are used only for that transaction.

Transaction processing system and method

Growing community of inventors

San Jose, CA, United States of America

Harry Otto Radke