Database duplication method of using remote copy and database duplication storage subsystem thereof

• US 6,895,417 B2
• Filed: 02/03/2003
• Issued: 05/17/2005
• Est. Priority Date: 06/03/1999
• Status: Expired due to Fees

• Current Assignee: Hitachi, Ltd.
• Original Assignee: Hitachi, Ltd.
• Inventors: Takamoto, Yoshifumi, Obara, Kiyohiro
• Primary Examiner(s): Mitrahi, Diane D.
• Assistant Examiner(s): Mofiz, Apu M
• Application Number:
  US10/356,508
• Publication Number:
  US 20030115224A1
• Time in Patent Office: 834 Days
• Field of Search: 707/6, 707/10, 707/20, 707/100, 707/202, 707/204, 705/404, 709/106, 709/213, 709/249, 711/29, 711/162, 714/20
• US Class Current: 1/1
• CPC Class Codes: G06F 11/2064 while ensuring consistency
• CPC Class Codes: G06F 11/2071 using a plurality of controllers
• CPC Class Codes: G06F 16/219 Managing data history or versioning querying versioned data G06F16/2474; querying temporal data G06F16/2477
• CPC Class Codes: G06F 16/2308 Concurrency control transaction processing G06F9/466
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: Y10S 707/99953 Recoverability
• CPC Class Codes: Y10S 707/99955 Archiving or backup

Abstract

A Database Management System (DBMS) of a main host system is directed by its agent to overwrite database table data (DB table data), which is stored in a DB buffer and put in and out by the DBMS, to the database table (DB table) on a main disk unit, and holds the updating of the DB table data in the DB table against a subsequent request of updating. A main disk control unit is directed by the agent to transfer the DB table data in the DB table to a DB table on a subordinate disk unit by a subordinate disk control unit to duplicate the DB table data, and suspend the subsequent transfer of DB table data so that the DB table data on both disk units are in a state of matching, thereby enabling the DBMS of the subordinate host system to refer to the copied DB table.

Claims

1. A computer program stored on a computer readable storage medium for controlling, when executed by a computer and a storage subsystem connected to the computer to perform the steps of:

directing the computer to change into a back up mode in which the computer updates a database table stored in the storage subsystem by using data stored in the computer and stops update of the database table after updating of the database table has been completed;

directing the storage subsystem to transfer the database table to a second storage subsystem connected to the storage subsystem via a network; and

directing the computer to change into a normal mode in which the computer updates the database table.

2. A computer program according to claim 1, wherein the computer program controls the computer and storage system to repeat the steps at a certain time interval.

3. A computer connected to a storage subsystem comprising:

means for changing into a back up mode in which the computer updates a database table stored in the storage subsystem by using data stored in the computer and stops update of the database table after updating of the database table has been completed;

means for directing the storage subsystem to transfer the database table to a second storage subsystem connected to the storage subsystem via a network; and

means for changing into a normal mode in which the computer updates the database table.

4. A computer according to claim 3, further comprising:

a buffer,

wherein the buffer stores data to be used for updating the database table.

5. A computer according to claim 4, wherein the computer changes the modes repeatedly.

6. An agent program executed by a computer for controlling the computer and a storage subsystem connected to the computer, comprising:

means for directing the computer to change into a back up mode in which the computer updates a database table stored in the storage subsystem by using data stored in the computer and stops update of the database table after updating of the database table has been completed;

means for directing the storage subsystem to transfer the database table to a second storage subsystem connected to the storage subsystem via a network; and

means for directing the computer to change into a normal mode in which the computer updates the database table.

7. An agent program according to claim 6, wherein the agent program is executed repeatedly.

8. A computer connected to a storage subsystem comprising:

means for changing into a back up mode in which the computer updates a database table stored in the storage subsystem by using data stored in the computer and suspends updating the database table;

means for directing the storage subsystem to transfer the database table to a second storage subsystem connected to the storage subsystem via a network; and

means for changing back into a normal mode in which the computer updates the database table.

9. An agent program executed by a computer for controlling the computer and a storage subsystem connected to the computer, comprising:

means for directing the computer to change into a back up mode in which the computer updates a database table stored in the storage subsystem by using data stored in the computer and suspends updating the database table;

means for directing the storage subsystem to transfer the database table to a second storage subsystem connected to the storage subsystem via a network; and

means for directing the computer to change back into a normal mode in which the computer updates the database table.