Figure 7-3 illustrates the rs_subcmp process during subscription reconciliation.
Figure 7-3: Subscription reconciliation
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.
