Data base duplication method of using remote copy and database duplication storage subsystem thereof

• US 6,549,920 B1
• Filed: 06/02/2000
• Issued: 04/15/2003
• 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): Mizrahi, Diane D.
• Assistant Examiner(s): MOFIZ, APU M
• Application Number:
  US09/585,281
• Time in Patent Office: 1,047 Days
• Field of Search: 707/10, 707/20, 707/6, 707/100, 707/202, 707/204, 705/404, 709/106, 709/213, 709/249, 711/129, 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

In a duplicated storage subsystem, 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 of the main disk 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 way of a subordinate disk control unit thereby to duplicate the DB table data, and suspends 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 a copied DB table in a state of matching.

Claims

1. A data duplication control method for a system which includes a main system having a first processor system in which a first DBMS operates and a first storage subsystem connected to said first processor system and a subordinate system having a second processor system in which a second Database Management System (DBMS) operates and a second storage subsystem connected to said second processor system, with said first and second storage subsystem being connected to each other, said method comprising:

a step, which is implemented by said first DBMS by being directed by said first processor system, of overwriting database table data (will be termed “

DB table data”

) which is stored in a cache and put in and out by said first DBMS to the database table (will be termed “

DB table”

) of said first storage subsystem, and holding the updating of the DB table data in the DB table against a subsequent request of updating of the DB table data; and

a step, which is implemented by said first storage subsystem by being directed by said first processor system, of transferring the DB table data in the DB table of the self storage subsystem to the DB table of said second storage subsystem thereby to duplicate the DB table data, and suspending the subsequent transfer of DB table data so that the DB tables of said first and second storage subsystems are in a matched state, thereby enabling said second DBMS to refer the copied DB table in a matched state.

2. A data duplication control method according to claim 1 or claim 4, wherein the DB table data which has been overwritten to the DB table of said first storage subsystem is stored into a buffer for remote copy of said first storage subsystem, and said first storage subsystem transfers and copies the DB table data in said buffer to the DB table of said second storage subsystem in response to the command of duplication, thereby duplicating the DB table data.

3. A data duplication control method according to claim 1 or claim 2, wherein storage location information of the DB table of said first storage subsystem for the DB table data which has been overwritten to the DB table is stored into a memory of said first storage subsystem, and said first storage subsystem reads the location information out of said memory and transfers and copies the DB table data in the DB table as indicated by the location information to the DB table of said second storage subsystem in response to the command of duplication, thereby duplicating the DB table data.

4. A data duplication control method for a system which includes a main system having a first processor system in which a first DBMS operates and a first storage subsystem connected to said first processor system and a subordinate system having a second processor system in which a second DBMS operates and a second storage subsystem connected to said second processor system, with said first and second storage subsystems being connected to each other, said method comprising,

a step, which is implemented by said first DBMS by being directed by said first storage subsystem, of overwriting DB table data which is stored in a cache and put in and out by said first DBMS to the DB table of said first storage subsystem, and holding the updating of the DB table data in the DB table against a subsequent request of updating of the DB table data, and

a step, which is implemented by said first storage subsystem, of transferring and copying the DB table data of the DB table of the self storage subsystem to the DB table of said second storage subsystem thereby to duplicate the DB table data, and suspending the subsequent transfer of DB table data so that the DB tables of said first and second storage subsystems are in a state of matching,

thereby enabling said second DBMS to refer the copied DB table in a state of matching.

5. A duplicated storage subsystem which includes a first storage subsystem having a first external storage control unit and a first external storage unit and is connected to a first processor system, and a second storage subsystem having a second external storage control unit and a second external storage unit and is connected to a second processor system, with said first and second external storage control units being connected to each other, wherein said first external storage control unit includes means of overwriting data, which is held in a cache of said first processor system, to said first external storage unit;

means of holding the updating of the data which has been written to said first external storage unit against a subsequent request of updating;

means of transferring the data to said second storage subsystem thereby to duplicate the data; and

means of suspending the subsequent transfer of data from said first external storage unit to said second storage subsystem, so that the data stored in said first and second storage subsystems are in a state of matching.

6. A duplicated storage subsystem according to claim 5, wherein said first external storage control unit includes means of storing the data which has been overwritten to said first external storage unit into a buffer of said first external storage control unit, and means of transferring the data in said buffer to said second storage subsystem in response to the command of duplication, thereby duplicating the data.

7. A duplicated storage subsystem according to claim 5, wherein said first external storage control unit includes means of storing storage location information of said first external storage unit for the data which has been overwritten to said first external storage unit into a memory of said first external storage control unit;

and means of reading the location information out of said memory in response to the command of duplication and transferring the data which is stored in said first external storage unit as indicated by the location information to said second storage subsystem, thereby duplicating the data.

8. A duplicated storage subsystem according to claims 5, 6 or 7, wherein said first external storage control unit and said second external storage control unit are linked through an exclusive communication line to carry out the data communication.

9. A duplicated storage subsystem according to claims 5, 6 or 7, wherein said first external storage control unit and said second external storage control unit are linked through a switch or a network to carry out the data communication.