You must quiesce the primary database to suspend update activities until the standby database is materialized and the Mirror Replication Agent is initialized.
For ASE only: You must have a System
Administrator user role in the primary Adaptive Server to perform
this procedure.
Any activity that would change the schema in the primary database should not be allowed to take place while Replication Agent is initializing. Select a time when there are no users on the system or quiesce the primary database.
To quiesce the primary database
For Oracle only: Quiesce an Oracle database:
ALTER SYSTEM QUIESCE RESTRICTED
Steps 2 and 3 are for ASE only.
Log in to the primary database server with a System Administrator user role.
Quiesce the primary database.
If you use snapshot materialization for a standby database in Adaptive Server, use the following command to quiesce the primary database:
quiesce database MA_setup hold pdb
where:
MA_setup is a user-defined tag that identifies the database.
pdb is the name of the primary database.
If you use the snapshot materialization mount database option for a standby database in Adaptive Server use the following command to quiesce the primary database:
quiesce database MA_setup hold pdb for external dump to pdb_manifest
where:
MA_setup is a user-defined tag that identifies the database.
pdb is the name of the primary database.
pdb_manifest is the name of the manifest file.