Steven E Roach

US Patent:

6658513, Dec 2, 2003

Filed:

Oct 10, 2000

Appl. No.:

09/685623

Inventors:

Mark A. Boonie - Hopewell Junction NY
Mark A. Lehrer - Poughkeepsie NY
Peter Lemieszewski - Poughkeepsie NY
Susan Anderson Pavlakis - Bethel CT
Steven Edwin Roach - Lagrangeville NY
Mark T. Spies - Poughkeepsie NY
Peter G. Sutton - Lagrangeville NY

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1200

US Classification:

710200, 710240, 710241

Abstract:

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.

US Patent:

8301609, Oct 30, 2012

Filed:

Sep 16, 2011

Appl. No.:

13/234346

Inventors:

Robert O. Dryfoos - Hopewell Junction NY, US
Christopher D. Filachek - Lagrangeville NY, US
Mark A. Lehrer - Hyde Park NY, US
Steven E. Roach - Lagrangeville NY, US
Michael J. Shershin - Poughkeepsie NY, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 17/30

US Classification:

707704, 707809

Abstract:

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.