International Business Machines Corporation

Frederick Stephen Perry

David Wayne Moore

A recovery utility apparatus for expediting recovery time during failure of one or more database data sets is provided. A backup copy restore utility is configured to read and restore a backup copy of the database data set. A change accumulation manager is configured to read detail records in an incomplete change accumulation data set. A log manager is configured to read a log to derive updates subsequent to a merge end point, wherein the updates are reflective of spill records. An image copy restore utility is configured to apply the detail records to the backup copy to thereby create a restored database data set. A database update manager is configured to apply the updates to the restored database data set.

System and method for parallel primary and secondary backup reading in recovery of multiple shared database data sets

The present invention establishes a merge end point in logs reflecting a sharing session with a common database. The merge end point is established at an earlier point to thereby reduce the number of unmergeable records. The system of the present invention includes a log archive module which determines the position of each log volume end-start point in the logs. A database recovery control module receives the positions of the log volume end-start points and determines the most recent log volume end-start point for each log. The database recovery control module next determines which of the most recent log volume end-start points has the earliest time value. This log volume end-start point is the latest identifiable point wherein all log records for all logs will be committed and is selected as the merge end point. A change accumulation utility is able to incorporate the merge end point in a CADS to separate unmergeable and mergeable log records.

Growing community of inventors

San Jose, CA, United States of America

Frederick Stephen Perry