HPE Shadowbase Compare is designed to provide you with accurate information describing the consistency between two copies of your HPE NonStop data, regardless of the block or file/table structure, partitioning, index or alternate key layouts, etc. The data being compared does not require the files/tables to match in structure, which allows the data to be the same or different and provides advanced availability when performing zero downtime migrations.
Shadowbase Compare supports verifying your Enscribe, SQL/MP, and SQL/MX datasets, and is most commonly used in business continuity (BC) architectures to provide assurance that the data between the copies is consistent. It works alongside any data replication product. It supports comparing active and off-line databases, in all BC architectures (active/passive, sizzling-hot-takeover, and active/active), regardless of where the data is being updated. It integrates with the Shadowbase data replication engine to eliminate any “false-positive” comparisons that can otherwise occur due to replication latency.
Shadowbase Compare provides information at the file/table aggregate level, as well as down to the individual records/rows, and fields/columns. It is impossible to resolve or repair data issues when you do not know the primary keys of the offending records/rows and the specific data content that mismatches!
Shadowbase Compare is fast, using advanced data compression algorithms to reduce network traffic and improve efficiency. Our SQL/MP and SQL/MX features and comparisons are unrivaled, and we are working to enhance the performance of our Enscribe comparisons to incorporate the same technologies. Shadowbase Compare easily installs into database environments without application modification, and leverages NonStop fundamentals to provide parallelism and to scale even the largest of comparisons.
HPE Shadowbase Repair is a feature that assists with correcting or repairing SQL/MP or SQL/MX database discrepancies between two tables. It works on any two database tables, provided they are both of the same type (MP or MX), and does not require the Shadowbase replication engine. Shadowbase Repair is also particularly useful in BC data replication environments, where it reads the Shadowbase Compare table of differences, and repairs the discrepancies when the data do not match.
Talk with us or your HPE account representative to learn how easy it is to audit your NonStop data and prove your data’s consistency.
Please reference our Newsletter Disclaimer.