Given the discussion thus far, it will be appreciated that, in general terms, an exemplary method, according to an aspect of the invention, includes the operations of selecting tables based on timestamp columns to obtain tables changed during a given time period (operation 220); splitting the selected tables into data blocks based on given partition ranges (operation 224); incrementally copying changes to data of the data blocks into datasets (operation 228); 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 (operation 232); and comparing data of a source site and a target site based on data blocks having the specified timestamp (operation 236).

In example embodiments, responsive to the comparing data indicating sameness:

- a tablespace with inconsistent data, as identified by a second structured query language query, is unloaded based on concrete data blocks having different data at the source site and the target site (operation 244); a difference in the inconsistent data is determined (operation 248); and data associated with an earlier timestamp is replicated to restore data associated with a log update of the source site to ensure data consistency in the target site (operation 252).

In example embodiments, the data of the source side and the target side are identified as a trusted consistency benchmark (operation 216).

In example embodiments, one or more tablespaces are identified using the first structured query language query queries.

In example embodiments, the first structured query language query is one of a select count query and a select average value query.

In example embodiments, the splitting the selected tables into data blocks is based on block numbers defined based on a parameter BLOCKNUM in a configuration file.

In example embodiments, a table space split (TSS) module, an incremental copy blocks (ICB) module, an unload blocks with timestamp (UBT) module, and a concrete blocks comparison (CBC) module are instantiated, wherein the step of splitting the selected tables into data blocks is carried out with the table space split (TSS) module; the step of incrementally copying the changes to the data of the data blocks into the datasets is carried out with the incremental copy blocks (ICB) module; the step of unloading the one or more tablespaces is carried out with the unload blocks with timestamp (UBT) module; and the step of comparing the data is carried out with the concrete blocks comparison (CBC) module.

In one aspect, a computer program product comprises 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 (operation 220); splitting the selected tables into data blocks based on given partition ranges (operation 224); incrementally copying changes to data of the data blocks into datasets (operation 228); 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 (operation 232); and comparing data of a source site and a target site based on data blocks having the specified timestamp (operation 236).

In one aspect, a system comprises a memory and at least one processor, coupled to the memory, and operative to perform operations comprising selecting tables based on timestamp columns to obtain tables changed during a given time period (operation 220); splitting the selected tables into data blocks based on given partition ranges (operation 224); incrementally copying changes to data of the data blocks into datasets (operation 228); 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 (operation 232); and comparing data of a source site and a target site based on data blocks having the specified timestamp (operation 236). Refer now to FIG. 5.

Various aspects of the present disclosure are described by narrative text, flowcharts, block diagrams of computer systems and/or block diagrams of the machine logic included in computer program product (CPP) embodiments. With respect to any flowcharts, depending upon the technology involved, the operations can be performed in a different order than what is shown in a given flowchart. For example, again depending upon the technology involved, two operations shown in successive flowchart blocks may be performed in reverse order, as a single integrated step, concurrently, or in a manner at least partially overlapping in time.

A computer program product embodiment (“CPP embodiment” or “CPP”) is a term used in the present disclosure to describe any set of one, or more, storage media (also called “mediums”) collectively included in a set of one, or more, storage devices that collectively include machine readable code corresponding to instructions and/or data for performing computer operations specified in a given CPP claim. A “storage device” is any tangible device that can retain and store instructions for use by a computer processor. Without limitation, the computer readable storage medium may be an electronic storage medium, a magnetic storage medium, an optical storage medium, an electromagnetic storage medium, a semiconductor storage medium, a mechanical storage medium, or any suitable combination of the foregoing. Some known types of storage devices that include these mediums include: diskette, hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or Flash memory), static random access memory (SRAM), compact disc read-only memory (CD-ROM), digital versatile disk (DVD), memory stick, floppy disk, mechanically encoded device (such as punch cards or pits/lands formed in a major surface of a disc) or any suitable combination of the foregoing. A computer readable storage medium, as that term is used in the present disclosure, is not to be construed as storage in the form of transitory signals per se, such as radio waves or other freely propagating electromagnetic waves, electromagnetic waves propagating through a waveguide, light pulses passing through a fiber optic cable, electrical signals communicated through a wire, and/or other transmission media. As will be understood by those of skill in the art, data is typically moved at some occasional points in time during normal operations of a storage device, such as during access, de-fragmentation or garbage collection, but this does not render the storage device as transitory because the data is not transitory while it is stored.

Computing environment 100 contains an example of an environment for the execution of at least some of the computer code involved in performing the inventive methods, such as database management system 200 incorporating aspects of the invention. In addition to block 200, computing environment 100 includes, for example, computer 101, wide area network (WAN) 102, end user device (EUD)