Quiesces the primary database in preparation for Mirror Replication Agent initialization.
pdb_quiesce hold [, for_dump [, manifest_file]]
pdb_quiesce release
The keyword for the quiesce database hold action.
The keyword for the quiesce database release action.
The optional keyword for the quiesce database hold for external dump action.
The name of the manifest file created by quiesce database.
pdb_quiesce hold
This command tells Mirror Replication Agent to invoke the quiesce database hold command for the primary database.
pdb_quiesce hold, for_dump
This command tells Mirror Replication Agent to invoke the quiesce database hold for external dump command for the primary database.
pdb_quiesce hold, for_dump, "%TEMP%\mypubs_file"
This command tells Mirror Replication Agent to invoke the quiesce database hold for external dump command, with the extension for creating for a manifest file.
pdb_quiesce release
This command tells Mirror Replication Agent to invoke the quiesce database release command for the primary database.
You cannot quiesce the primary database using pdb_quiesce, unless the Mirror Replication Agent user login in the primary database has a System Administrator role.
When pdb_quiesce is invoked, Mirror Replication Agent invokes quiesce database for the primary database, using a generated tag name with the following format:
ra_pdb_tag
where pdb is the name of the primary database.
If the length of the generated tag name exceeds the
primary data server limit for identifier names, the tag name is
truncated to the maximum allowed size.
See the Adaptive Server Enterprise Reference Manual and System Administration Guide for more information about the quiesce database command.
You must quiesce the primary database before you initialize the Mirror Replication Agent with the ra_init command.
After you initialize the primary dabatase with pdb_init, you must not allow any DDL operations in the primary database before it is quiesced for the Mirror Replication Agent initialization.
The pdb_quiesce command returns an error if the Mirror Replication Agent user login in the primary database does not have a System Administrator role.
The pdb_quiesce command is valid when the Mirror Replication Agent is in either Admin or Replicating state.
