International Business Machines Corporation

David Wayne Moore

Vern Lee Watts

Karen Alicia Ranson

John Terry Langley

Gregory Walter Vance

Harley A Beier

Donald Prentiss Terry

Frederick Stephen Perry

Robert Frederic Kern

Lawrence Edward Sullivan

Various embodiments of a computer system and computer program product backup a dataset. An input image copy of the dataset is read, wherein the input image copy is prior to a start of dataset reorganization. A cursor value associated with reorganization of said dataset is determined. A backup copy is produced based on the input image copy, the changes from the log and the cursor value.

Non-disruptive backup copy in a database online reorganization environment

Various embodiments of a computer-implemented method backup a dataset. An input image copy of the dataset is read, wherein the input image copy is prior to a start of dataset reorganization. A cursor value associated with reorganization of said dataset is determined. A backup copy is produced based on the input image copy, the changes from the log and the cursor value.

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

A method and apparatus for merging log data for recovering one or more database data sets to any point-in-time in a single pass of log data sets. Using disaster recovery technology, the invention may be implemented to provide a method to reduce the time that a broken database is unavailable by processing recovery input data in parallel and recovering multiple database data sets, including areas, simultaneously. The invention reduces operational complexity and resource constraints experienced by IMS customers trying to recover database data sets especially in a data sharing environment. The invention simplifies the recovery process by eliminating both the need for change accumulation and the need to run separate recovery jobs for each database data set requiring recovery, thereby reducing the impact of recovery on system resources.

Database recovery to any point in time in an online environment utilizing disaster recovery technology

System and method for recovery of multiple shared database data sets using multiple change accumulation data sets as inputs

A method and apparatus to synchronize recovery logs transmitted to a remote site for recovering related databases having different logical structuring. In one embodiment, the related databases are a hierarchial structured database such as IMS and a relational structured database such as DB2.

Growing community of inventors

Morgan Hill, CA, United States of America

David Wayne Moore