International Business Machines Corporation

Richard L Stone

Andrew Coleman

Mary E Vendryes

Edmond A Pruul

John A Henry

Jack Chiu-Chiu Yuan

Steve T Kuo

James M Showalter

Bruce E Naylor

Thomas J Szczygielski

Barbara A Maslak

Richard Dale Housh

Gerald LeRoy Carpenter

A method, apparatus, and article of manufacture for accessing a database management system. An application programming interface (API) provides a plurality of simplified procedures that allow an application program executed by the computer to access a database management system (DBMS) by creating an authorized connection between the application program and the DBMS. The application program invokes the simplified procedures of the API, the invoked procedures generate at least one supervisor call (SVC) interrupt that transfers control to an SVC Service Routine, and the SVC Service Routine connects to a Cross Coupling Facility (XCF) that interfaces to an Open Transaction Manager Access (OTMA) component of the DBMS.

Application programming interface for creating authorized connections to a database management system

A computer system provides registration of resource for synchronization point processing. Resources include file systems, data bases, and protected conversations. A resource becomes protected by the system when it is registered in the application's execution environment. The execution environment includes but is not exclusive to the interactive environment. Accordingly the invention provides an efficient and uniform method for identification of protected resources. The registration facility is separate from the application. Thus, the users of applications, application program developers, system administrators and operators need not have to consider or design a registration facility but only involve the one provided. A protected resource manager, through its adapter, can modify, at any time, the registration information, either by adding missing information or by changing the existing information. A resource registers only for the work unit in which it wishes to participate. An application could have several work units. A resource can register for two work units in the application or two resources can register for a single work unit or both.

Registration of resources for commit procedures

A computer operating system selects a one or two-phase commit procedure for resources to optimize the overall commit process. The optimization utilizes the more efficient one-phase commit procedure when possible and reserves the less efficient two-phase commit procedure for situations where the two-phase commit procedure is required to protect critical resources. If the resources include a protected conversation or two or more resources in the update mode then the two-phase commit procedure is utilized for these resources. Read-only resources or a single resource in the update mode that support one-phase commit are subject to the one-phase commit procedure. To further optimize the overall process, a plurality of resources are registered in a table, which table may reside in the operating system. The registrations include information about the resources and/or work requests which indicate what type of commit procedure is required. Thus, the operating system need not waste time consulting with resource managers after the registrations are made, before deciding what type of commit procedure is required.

Optimization of commit procedures by utilizing a two-phase commit

Growing community of inventors

Johnson City, NY, United States of America

Richard L Stone