Database duplication method of using remote copy and database duplication storage subsystem thereof
First Claim
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 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 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.
0 Assignments
0 Petitions
Accused Products
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.
-
Citations
9 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 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 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. - View Dependent Claims (3, 4)
-
-
2. 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. - View Dependent Claims (6, 7, 8, 9)
- means of holding the updating of the data which has been written to said first external storage unit against a subsequent request of updating;
Specification