Online repair of a replicated table
AssigneeInternational Business Machines Corporation
InventorsRajesh Naicken, Clarence Pruet, Konduru Rajakumar
Life of this patent
Estimating the term…
Abstract
A method, system and article of manufacture implementing the method repairs a table. A replication environment has a first replicate comprising a source table on a source server and a target table on a target server. The source server transmits replication data from the source server with repair data from the source server to the target table in accordance with a commit order of the replication data and the repair data. The target server applies the repair data and the replication data to the target table based on the commit order.
Claims40
A method of repairing a table in a replication environment having a first replicate comprising a source table of a source server and a target table of a target server, comprising:
- receiving, by said target server, replication data from said source server with repair data from said source table of said source server in accordance with a commit order of said replication data and said repair data;
- and
- applying, at said target server, said repair data and said replication data to said target table based on said commit order.
An article of manufacture comprising a computer usable medium embodying one or more instructions executable by a computer for performing a method of repairing a table in a replication environment having a first replicate comprising a source table of a source server and a target table of a target server, said method comprising:
- transmitting, by said source server, replication data from said source server with repair data from said source table of said source server in accordance with a commit order of said replication data and said repair data;
- and
- applying, at said target server, said repair data and said replication data to said target table based on said commit order.
A computer system to repair a table in a replication environment having a first replicate comprising a source table of a source server and a target table of a target server, comprising:
- a conduit comprising replication data from said source server with repair data from said source table of said source server in accordance with a commit order of said replication data and said repair data;
- and
- a target table comprising said repair data and said replication data.
A method of repairing a plurality of tables comprising:
- creating a first repair job that repairs a first table of said plurality of tables;
- creating a second repair job that repairs a second table of said plurality of tables;
- determining whether there is a referential constraint between said first table and said second table;
- and
- in response to said determining that a referential constraint exists between said first table and said second table, executing said first repair job and said second repair job based on said referential constraint.
Dependencies are inferred from the claim text.