Abstract: 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.

Abstract: 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.