The Replication Server System Database (RSSD) is an Adaptive Server database that contains the Replication Server system tables. Each Replication Server requires an RSSD and each RSSD holds the system tables for one Replication Server. The Adaptive Server that manages the RSSD can also manage client databases.
The Replication Server system tables are loaded into the RSSD during Replication Server installation. System tables hold information that Replication Server requires to send and receive replicated data, and include:
Descriptions of replicated data and related information
Security records for Replication Server users
Routing information for other sites
Access methods for the local databases
Other administrative information
See Chapter 8, “Replication Server System Tables,” in the Replication Server Reference Manual for a comprehensive list of system tables.
System table contents are modified during Replication Server activities, such as the execution of RCL commands or Sybase Central procedures. Only the Replication System Administrator, or members of the rs_systabgroup group, can alter the system tables.
To query the system tables and find status information:
RSM – Use Sybase Central to view replication system details and properties. See the Replication Server plug-in help in Sybase Central.
Use Replication Server’s system information or system administration commands. See “System Information Commands” and “System Administration Commands” in Chapter 1, “Introduction to the Replication Command Language,” in the Replication Server Reference Manual.
Use Adaptive Server stored procedures to display information about the replication system. See Chapter 5, “Adaptive Server Commands and System Procedures” in the Replication Server Reference Manual.
WARNING! RSSD tables are for internal use by Replication Server only. You should never modify RSSD tables directly unless directed by Sybase Technical Support.
The RSSD is dedicated to the Replication Server that it supports; do not use it to store user data. However, a single data server may contain the RSSD and user databases. The database device space for the RSSD must be at least 20MB (10MB for data and 10MB for the log). It is best to put the database and the database log on separate devices.
A replication agent is needed for the RSSD if the Replication Server is the source for any route. If this is true, Replication Server distributes some of the information in its RSSD to other Replication Servers. See Chapter 6, “Managing Routes” for more information.
