RSSD System Table Modifications

There are several changes to system tables in the Replication Server System Database (RSSD) to support SQL statement replication.

These system tables in the RSSD support SQL statement replication:
  • rs_dbrepsstatus column includes 4 new sets of 2-bit sets, each of which corresponds to a DML filter. The first bit of a set indicates if it is an empty filter and the second bit indicates if it is a negative statement set.

  • rs_dbsubsetstype column includes four new types: U, L, I, and, S corresponding to the DML UDIS filters. In this case, L is used for delete instead of D.

  • rs_objectsattributes column includes five new bits; one for each U, D, I, or S operation, and one to indicate if a table replication definition has fewer columns than the number of columns in the table schema.

    A system function replication definition, rs_sqldml, also supports SQL statement replication.