International Business Machines Corporation

Steven Edwin Roach

Christopher Daniel Filachek

Michael J Shershin

Mark A Lehrer

Peter Grimm Sutton

Robert O Dryfoos

Mark Richard Gambino

Mark A Boonie

Glenn W Sears, Jr

Daniel Howard Jacobs

George Edward Graffius, Iii

Susan Anderson Pavlakis

Mark Spies

Peter Lemieszewski

According to at least one embodiment, a method, a computer system, and a computer program product for minimizing I/O operations when validating databases are provided. The present invention may include creating a corresponding system-managed chain database for an application database, the chain database comprising a list of one or more dynamically allocated records, if present, for one or more fixed entries in the application database, wherein each of the fixed entries comprises a respective chain database array item in the chain database; scanning, via a validation utility, one or more chain database array items; marking each of the one or more dynamically allocated records listed in the chain database for the fixed entries as found; and checking, via an indicator with various states, if the one or more dynamically allocated records for the one or more fixed entries are listed in the respective chain database array item.

Minimizing I/O operations when validating flat databases

A method for identifying a set of records in a database for relocation during an on-line database reorganization (ODBR) process. The relocating includes, for each of the records in the set: requesting a record reorganization lock (RRL) on the record, receiving the RRL, retrieving data from the current location of the record, storing the data in the new location of the record, and releasing the RRL. A request is received to update a target record in the set of records with updated data. The receiving of the request is from an application and overlaps in time with at least a portion of the relocating. Independent of the application, a RRL is received on the target record and the target record is updated by writing target data to the target record in the current location and writing the target data to the target record in the new location.

Collision detection and data corruption protection during an on-line database reorganization

Changes in locking configurations are managed. A locking configuration includes one or more locking facilities and the one or more locking facilities include one or more locks. When a change in a locking configuration, either planned or unplanned, is detected, one or more of the locks are redistributed. For example, one or more of the locks affected by the change are moved from one or more of the locking facilities to one or more other locking facilities. This redistribution is independent of the location of the data associated with the one or more locks being moved. Thus, data and locks may be moved independently of one another and without affecting one another. Further, the redistribution can take place while the system is available or mostly available, thereby minimizing downtime.

Managing locks affected by planned or unplanned reconfiguration of locking facilities

Growing community of inventors

Lagrangeville, NY, United States of America

Steven Edwin Roach