International Business Machines Corporation

Brian Keith Howell

James Willis Pickel

Curt Lee Cotner

Jeffrey William Josten

Richard A Crus

Hugh J Smith

Benjamin Janes Beck

Jay A Yothers

David Joseph Wisneski

Tammie Dang

Claire Willey McFeely

Charles H Lin

Fung Lee

Harry Otto Radke

Hui-An Lee

Jennifer W Ou

A method and system for providing package resolution in a database system is disclosed. The method and system comprise providing a statement within a server which allows an application to identify a list of package collections. The method and system further includes executing the statement to obtain the appropriate package. A system and method in accordance with the present invention provides a new current package path value, which is set via a statement referred to as Set Current Package Path. The SET CURRENT PACKAGE PATH statement allows the application to supply a precedence list of qualified package collections during execution time, therefore the scheme for resolving packages can be changed at any point during execution. The SET CURRENT PACKAGE PATH statement improves application development by making the package resolution mechanism less error prone and less tedious for the application developer, while providing an optimal-performance solution in the client-server environment.

Package resolution mechanism for database systems

A shared memory device called the Coupling Facility (CF) is used to record the indoubt transaction entries for each member of the database cluster, avoiding the CPU cost and elapsed time impact of persisting this information to disk (either via a log write or a relational table I/O). The CF provides full read/write access and data coherency for concurrent access by all the members in the database cluster. At any given point in time, the CF will contain the full list of indoubt transactions for the entire database cluster. CF duplexing is used to guarantee the integrity of the CF structure used for the indoubt list. In the event of complete loss of both CF structures (which will not happen except in major disaster situations), data sharing group restart processing can reconstruct the CF structures from the individual member logs.

High performance support for XA protocols in a clustered shared database

A method and apparatus for configuring a plurality of server systems. In one implementation, the method includes configuring the plurality of server systems as a first database having a group name and a group port, and configuring a subset of the plurality of server systems as a second database having a subset name and a subset port. The first database is accessible by a client application via the group name and the group port for storage of data in the first database, and the second database is accessible by a client application via the subset name and the subset group for storage of data in the second database.

Method and apparatus for configuring a plurality of server systems into groups that are each separately accessible by client applications

A method and system of subsetting a group of server systems configures a server system with a group name and a group port, and with at least one subset name and subset port. The server system, when activated, reads its configuration and registers with a system routing entity as being part of the group name and the group port, and as being part of the subset name and the subset port. In this manner, server systems can be targeted via its subset name and subset port, while also accessible via the common name and port for the group. If the group includes a workload balancer, the server system also registers with the workload balancer using the group name and the subset name, such that workload balancing is provided for the subset.

Method and system of subsetting a cluster of servers

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

The system, method, and program of this invention allows a two-phase commit protocol to work properly, even when the client acting as the coordinator does not have a log to record two-phase state information. In a preferred embodiment, the client in a client/server distributed transaction processing system is a personal computer. The client, without a recovery log, acts as a coordinator of a commit process. The coordinator migrates, i.e., passes, responsibility for resynchronization, and any associated logging requirement, to a server, e.g., to any of the connected relational database management system (RDBMS) servers, which is a participant in the transaction. The server uses its own recovery log for use in satisfying the logging requirement.

System, method and program for performing two-phase commit with a

Videoconferencing control panel

Growing community of inventors

San Jose, CA, United States of America

Brian Keith Howell