Abstract: A method of automated disaster site recovery of a DB2 subsystem is presented. The method reads parameters contained in a user modifiable control dataset of recovery parameters for objects, systems, and applications to be recovered. The method also reads a DB2 system catalog containing recovery requirements. The method then creates recovery jobs based on the control dataset parameters and DB2 system catalog requirements. Control cards are created that will automatically submit the recovery jobs to a CA7 scheduling system via a batch terminal interface such that dependent recovery jobs will not be submitted until their pre-requisite recovery jobs have completed. An installation verification job is created that selects a row from each table being recovered and ensures that the recovery was successful. The control dataset can be updated with new application, object, and system recovery parameters on an as needed basis without affecting the recovery job creation process.

Abstract: A method of automated disaster site recovery of a DB2 subsystem is presented. The method reads parameters contained in a user modifiable control dataset of recovery parameters for objects, systems, and applications to be recovered. The method also reads a DB2 system catalog containing recovery requirements. The method then creates recovery jobs based on the control dataset parameters and DB2 system catalog requirements. Control cards are created that will automatically submit the recovery jobs to a CA7 scheduling system via a batch terminal interface such that dependent recovery jobs will not be submitted until their pre-requisite recovery jobs have completed. An installation verification job is created that selects a row from each table being recovered and ensures that the recovery was successful. The control dataset can be updated with new application, object, and system recovery parameters on an as needed basis without affecting the recovery job creation process.