Data comparison without interruption to a database management system

A computer program product, comprising:

• one or more tangible computer-readable storage media and program instructions stored on at least one of the one or more tangible computer-readable storage media, the program instructions executable by a processor, the program instructions comprising:
• selecting tables based on timestamp columns to obtain tables changed during a given time period;
• splitting the selected tables into data blocks based on given partition ranges;
• incrementally copying changes to data of the data blocks into datasets;
• unloading one or more tablespaces identified using a first structured query language query corresponding to a specified timestamp based on output of the incrementally copying changes operation;
• and
• comparing data of a source site and a target site based on data blocks having the specified timestamp
• if the data of the source site and the target site are not the same:
• unloading a tablespace with inconsistent data, as identified by a second structured query language query, based on concrete data blocks having different data at the source site and the target site;
• determining a difference in the inconsistent data;
• and
• replicating data associated with an earlier timestamp to restore data associated with a log update of the source site to ensure data consistency in the target site.

A system comprising:

• a memory;
• and
• at least one processor, coupled to said memory, and operative to perform operations comprising:
• selecting tables based on timestamp columns to obtain tables changed during a given time period;
• splitting the selected tables into data blocks based on given partition ranges;
• incrementally copying changes to data of the data blocks into datasets;
• unloading one or more tablespaces identified using a first structured query language query corresponding to a specified timestamp based on output of the incrementally copying changes operation;
• and
• comparing data of a source site and a target site based on data blocks having the specified timestamp;
• if the data of the source site and the target site are not the same:
• unloading a tablespace with inconsistent data, as identified by a second structured query language query, based on concrete data blocks having different data at the source site and the target site;
• determining a difference in the inconsistent data;
• and
• replicating data associated with an earlier timestamp to restore data associated with a log update of the source site to ensure data consistency in the target site.