Patents of Demand P.A.
Automatically restoring data replication consistency without service interruption during parallel apply
A data replication method can begin with the detection of an inconsistency between records of a target table and corresponding records of a source table of a relational database management system (RDBMS) performing a parallel apply replication by an improved data replication manager. The target table can be a copy of the source table, both of which include multiple unique constraints and indexes. A timeframe that encompasses the records of the target table having the inconsistency can be determined. The timeframe can utilize a commit timestamp or a log sequence number. Consistency between the target table and the source table can be automatically restored for the determined timeframe through use of a reactive-apply process. Data suppression for updates is automatically restored once the copy is consistent. Transactions performed upon the target table by the reactive-apply process can be performed in parallel. Service at the source table and the target table can be uninterrupted.
INTERNATIONAL BUSINESS MACHINES CORPORATION
G G G
G06F G06F G06F
inventional inventional inventional
Xiao Austin F. Serge Jonathan
Li D'Costa Bourbonnais Wierenga