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)