Reconciling downstream RSSDs

  1. Run rs_subcmp against the above tables, specifying site B as the primary and site E as the replicate, with prsid = 2 in the where clauses. For example, the select statement for rs_columns should look like the following:

    select * from rs_columns where prsid in
          (select source_rsid from rs_routes
           where
            (through_rsid = 2 or through_rsid = 5)
             and dest_rsid = 5)
           and rowtype = 1
          order by objid, colname
    

Refer to Chapter 7, “Executable Programs,” in the Replication Server Reference Manual for more information on rs_subcmp. Refer to Chapter 8, “Replication Server System Tables,” in the Replication Server Reference Manual for more information on the RSSD system tables.