Invention Grant
- Patent Title: Database automated disaster recovery
- Patent Title (中): 数据库自动化灾难恢复
-
Application No.: US10907840Application Date: 2005-04-18
-
Publication No.: US07676692B2Publication Date: 2010-03-09
- Inventor: Michael T. Costlow , Manas Dasgupta
- Applicant: Michael T. Costlow , Manas Dasgupta
- Applicant Address: US NC Charlotte
- Assignee: Bank of America Corporation
- Current Assignee: Bank of America Corporation
- Current Assignee Address: US NC Charlotte
- Agency: Moore & Van Allen PLLC
- Agent Michael A. Springs
- Main IPC: G06F11/00
- IPC: G06F11/00

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.
Public/Granted literature
- US20060236151A1 DATABASE AUTOMATED DISASTER RECOVERY Public/Granted day:2006-10-19
Information query