U2 Replication File Continuity Checker

As more and more customers are using U2 Replication, they have inquired about how to ensure that our subscriber is synchronized with our publisher and not missing any updates. It is imperative for customers to have trust in the accuracy of the subscriber's database copy. 

This confidence is essential for relying on it in the event of a failover or for uninterrupted business reporting. This utility offers a continuity check between the publisher and subscriber files for U2 Replication, empowering customers with the confidence they need.

The utility and the documentation are available from our knowledge base, by searcing for Article Number 000055107 , or for the description 'U2 Replication File Checker' or using this link https://my.rocketsoftware.com/RocketCommunity/s/article/U2-Replication-File-Checker

The utiltly has undergone a closed beta and will initially be maintained by myself and updated via the knowledge base article before making it's way into UV and UD. All feedback is welcomed on this.

Hi Jonathan,

We installed your programs for Replication File Checker with success operating on Unidata 8.3.1 Windows Server 2022. Great work.

I have a few questions from our testing experience.

1. Performance (we have very large files that are replicated to the subscriber) some can have 10's of millions of records. what's your thoughts on optimising the process.
2. Running on the Publisher consumes a UDT lic can that be resolved by running as Phantom.

Thanks for your support

Darren,

There is a new version with a small tweak available from the knowledge base article. I'll attach the latest version here anyway as it had to have a tweak to work correctly on Windows because of a small difference in how the windows API used one parameter vs Unix.

Running the program as a phantom will not avoid the license cost, the program uses the socket api so when run as a phantom will be escalated to an iphantom and take a licence anyway.

In terms of optimizing the process for one file with 10 of millions of records, there is not a lot that can be done, as the process is optimized in terms of what it does using checksums to find differences. 

If you wanted to check several files at once, then you can start several subscriber programs using different a socket port , you can then have multiple publisher programs running each dealing with different files and connecting to the different socket ports on the subscriber.

Thanks,

As more and more customers are using U2 Replication, they have inquired about how to ensure that our subscriber is synchronized with our publisher and not missing any updates. It is imperative for customers to have trust in the accuracy of the subscriber's database copy. 

This confidence is essential for relying on it in the event of a failover or for uninterrupted business reporting. This utility offers a continuity check between the publisher and subscriber files for U2 Replication, empowering customers with the confidence they need.

The utility and the documentation are available from our knowledge base, by searcing for Article Number 000055107 , or for the description 'U2 Replication File Checker' or using this link https://my.rocketsoftware.com/RocketCommunity/s/article/U2-Replication-File-Checker

The utiltly has undergone a closed beta and will initially be maintained by myself and updated via the knowledge base article before making it's way into UV and UD. All feedback is welcomed on this.