To prepare Adaptive Server databases for replication, use rs_init.
rs_init:
- Creates the rs_lastcommit
system table.
- 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).
- Creates the rs_threads
system table.
- Loads the rs_initialize_threads and rs_update_threads stored procedures for the database.
- Creates the maintenance user login name and verify that the
maintenance user can log in to the database.
- Creates a connection from Replication Server to the
database, allowing Replication Server to manage the database.
If
the database has primary data,
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.