Replication Server 15.0.1 introduces dynamic SQL, master database replication, schema comparison, and manual data reconciliation. Several enhancements have also been made
to enable more efficient configuration and tuning of Replication
Server.
Monitors and Counters Enhancements
The process of monitoring the counters that provide performance information has been improved in Replication Server 15.0.1. Sampling and saving statistics to the RSSD now runs asynchronously, allowing you to execute other Replication Server commands or terminate the session while the sampling continues in the background.
Dynamic SQL for Enhanced Replication Server Performance
Dynamic SQL in Replication Server enhances replication performance by allowing Replication Server Data Server Interface (DSI) to prepare dynamic SQL statements at the target user database and to execute them repeatedly.
Master Database Replication
The Adaptive Server RepAgent thread now supports master database replication in Adaptive Server 15.0, ESD #2 and later. The master database can be replicated using warm standby with any version of Replication Server that supports warm standby, including Replication Server version 12.0 and later.
rs_subcmp Enhancement
In Replication Server 15.0.1, rs_subcmp uses a hash algorithm to improve its performance. Hash algorithm compresses the data in primary and replicated tables. The compressed data is then fetched by rs_subcmp.
Schema Comparison
In Replication Server 15.0.1, the rs_subcmp function has been expanded to include schema comparison between tables and databases. This is useful in comparing schema between two databases that may have the same data but different schemas.
Manual Data Reconciliation
The enhanced rs_subcmp command now supports manual reconciliation of inconsistent data through the creation of a reconciliation file. This allows you to verify the reconciliation statements before execution.
Created July 21, 2011. Send feedback on this help topic to Sybase Technical Publications:
pubs@sybase.com