Subscription Reconciliation

Subcription reconciliation is for recovering inconsistency in a replicate table and correcting the discrepancies.

Subscription Reconciliation
Figure 7-3 illustrates the r s underscore sub c m p process during subscription reconciliation. This is described in the following text.

During subscription reconciliation:

rs_subcmp connects to the primary data server and to the replicate data server using the replicate data server’s character set.
The primary data server converts all character data to the replicate data server’s character set (all rs_subcmp operations are performed in the replicate data server’s character set). The replicate data server’s character set, if it is different from the primary data server’s character set, must be installed at the primary data server.
rs_subcmp sends a select statement to both data servers. The sort order of each data server must be the same for this process to produce sensible results.