In the Mirror Activator system, the Mirror Replication Agent must control the secondary truncation point in the primary database. This requires you to stop and disable the RepAgent thread in the primary database when you convert an existing warm standby application to a Mirror Activator system.
WARNING! You must use the preserve secondary truncpt option when you execute sp_config_rep_agent to disable the RepAgent thread. If you do not preserve the secondary truncation point in the primary database, you will have to re-materialize the standby database before you resume replication to prevent data loss.
Use the following procedure to stop and disable the RepAgent thread in the primary database.
You must have a System Administrator user role in the
primary Adaptive Server to perform this procedure.
To stop and disable the RepAgent thread
Log in to the primary Adaptive Server with a System Administrator user role.
Stop the RepAgent thread in the primary database:
use pdb sp_stop_rep_agent pdb
where pdb is the name of the primary database.
Disable the RepAgent thread in the primary database:
sp_config_rep_agent pdb, ’disable’, ’preserve secondary truncpt’
where pdb is the name of the primary database.
Disabling the RepAgent thread allows the Mirror Replication Agent to reserve the logscan context in the primary database.
