Preparing Adaptive Server Databases for Replication

Use Sybase Central or rs_init to prepare Adaptive Server databases for replication.

  1. Create the rs_lastcommit system table.
  2. Load 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. Create the rs_threads system table.
  4. Load the rs_initialize_threads and rs_update_threads stored procedures for the database.
  5. Create the maintenance user login name and verify that the maintenance user can log in to the database.
  6. Create 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:

  • 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.

Parent topic: Prepare Databases for Replication
Related concepts
Manage the Maintenance User