Patent ID: 7676692

Claim:
A method of automated disaster site recovery of a relational database subsystem comprising: automatically accessing and reading parameters contained in a user modifiable control dataset, a control dataset defining recovery parameters for objects, systems, and applications to be recovered; automatically accessing and reading a relational database system catalog containing recovery requirements; automatically creating recovery jobs based on the control dataset parameters and relational database system catalog requirements; automatically creating control cards that will automatically submit the recovery jobs to a computer batch scheduling system such that dependent recovery jobs will not be submitted until their pre-requisite recovery jobs have successfully completed, wherein pre-requisite recovery jobs include one or more tablespace recovery jobs and their respective dependent recovery jobs include one or more index rebuild recovery jobs and wherein the control cards include list definition (LISTDEF) control cards designed to increase job recovery parallelism; and automatically creating an installation verification job that selects a row from each table being recovered and ensures that the recovery was successful and that the table data is available, wherein one job of the recovery jobs collects run-time statistics for all the recovery jobs and generates a file useable for reporting and trending and wherein the control dataset is configurable to be updated with revised or new application, object and system recovery parameters on an as needed basis without affecting the recovery job creation process.