Show TOC

System TablesLocate this document in the navigation structure

SAP Replication Server 15.7.1 SP200 includes several new system tables and changes to existing system tables.

See descriptions of the tables and related indexes in Replication Server System Tables in the Reference Manual.

New System Tables
  • rs_dependtbls – stores information about tables that are pending to add or remove from database replication definitions
  • rs_schemamap – stores information about schema mapping between primary database and replicate database
Changes to Existing System Tables
  • rs_articles – add an index on (objid)
  • rs_dbsubsets – add the status and priority columns
  • rs_dictionary – add a unique clustered index on (words)
  • rs_encryptionkeys – add a unique clustered index on (name)
  • rs_passwords – add:
    • A one to one relationship between the uid column in rs_passwords and the uid column in rs_users
    • An index on (uid)
  • rs_recovery – change the text column datatype length to binary(512).
  • rs_subscriptions – add:
    • The released , mechanism, tableowner, tablename, prsid, and num_selects columns.
    • A one to one relationship between the prsid column in rs_subscriptions and the prsid column in rs_dbsubset
    • The released column to the unique index on (subid, recovering, error_flag,, materializing, dematerializing, primary_sre,replicate_sre)
    • An index on (recovering, requestdate)
  • rs_targetobjs – add a unique clustered index on (dbid, objname, objowner , objtype)