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 Mirror Replication Agent 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 Mirror Replication Agent 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 Mirror Replication Agent 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 Mirror Replication Agent
thread
Log in to the primary database with a System Administrator user role.
Stop the Mirror Replication Agent thread in the primary database:
use pdb sp_stop_rep_agent pdb
where pdb is the name of the primary database.
Disable the Mirror Replication Agent 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 ASE Mirror Replication Agent thread allows the Mirror Replication Agent to reserve the logscan context in the primary database.
