Subcription reconciliation is for recovering inconsistency in a replicate table and correcting the discrepancies.
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.