Chapter 8: Replication Server System Tables

This chapter lists the system tables in the Replication Server System Database (RSSD) or Embedded RSSD (ERSSD). System tables are stored in a dedicated database in the system Adaptive Server or Adaptive Server Anywhere.

Access to the system tables is restricted to users with sa permission, or members of the rs_systabgroup group. The system tables are maintained by RCL commands. Avoid direct manipulation, except with rs_config. You can alter rs_config using the configure replication server command at the Replication Server.

For more information about the rs_systabgroup group, see repserver. For information about configure replication server, see configure replication server.

The system tables include the user-defined datatype rs_id that is defined as binary(8). It is used for columns that hold object names. For more information about identifiers, see “Identifiers”.

The rs_lastcommit and rs_threads system tables are documented in this chapter, although these tables are created and stored in each user database, not in the RSSD or ERSSD.