Preparation of Adaptive Server Databases for Replication

To prepare Adaptive Server databases for replication, use Sybase Central or rs_init.

Sybase Central or rs_init:
  1. Creates the rs_lastcommit system table.
  2. Loads the rs_update_lastcommit and rs_get_lastcommit stored procedures (for both primary and replicate databases) and the rs_marker stored procedure (for primary databases only).
  3. Creates the rs_threads system table.
  4. Loads the rs_initialize_threads and rs_update_threads stored procedures for the database.
  5. Creates the maintenance user login name and verify that the maintenance user can log in to the database.
  6. Creates a connection from Replication Server to the database, allowing Replication Server to manage the database.
If the database has primary data, Sybase Central or rs_init additionally:
  • Enables RepAgent at the Adaptive Server.

  • Enables and configures RepAgent at the database.

  • Sets the secondary truncation point to “valid” in the Adaptive Server database, preventing Adaptive Server from truncating database log records before RepAgent has read them.

  • Creates the RepAgent user name and password in the Replication Server, if necessary.

  • Starts RepAgent.

Refer to the Replication Server installation and configuration guides for your platform for details on each step.

Related concepts
Manage the Maintenance User