Placing a Database in Quiesce-Hold

Use Quiesce Hold to block updates to a database during a copy operation.

Quiesce hold allows you to block updates to one or more databases while you perform a disk unmirroring or external copy of each database device. Because no writes are performed during this time, the external, secondary copy of the database is identical to the primary image. While the database is in the quiescent state, read-only queries to operations on the database are allowed. You can load the external copy of the database onto a secondary server, ensuring that you have a transactionally consistent copy of your primary image.

Only database owners or system administrators can quiesce a database.

Note: If there are distributed or multidatabase transactions in the database in prepared state, SAP Control Center waits for 5 seconds for those transactions to complete. If they do not complete in 5 seconds, the quiesce database hold operation fails.

In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Databases.
Select one of:
- User Databases
- System Databases
- Temporary Databases
- Proxy Databases
Click the Name field of the database, then click the drop-down arrow and select Quiesce Hold.

In the Quiesce Database Hold wizard, choose from these options:

Input	Description
Tag Name	A tag name for the quiesce hold operation.
External Dump Option	Copy the database while updates to specified databases are suspended with the Quiesce Hold command. You must also specify: Manifest File – specify the path for the manifest file. Evaluate Dependencies – if you have not selected all the databases to be quiesced, allow the wizard to generate a list of databases that must be quiesced, along with your selected database, to ensure that the quiesce hold succeeds. The list of unselected databases that must be quiesced are indicated in the dependency matrix.

Input

Description

Tag Name

A tag name for the quiesce hold operation.

External Dump Option

Copy the database while updates to specified databases are suspended with the Quiesce Hold command. You must also specify:

Manifest File – specify the path for the manifest file.
Evaluate Dependencies – if you have not selected all the databases to be quiesced, allow the wizard to generate a list of databases that must be quiesced, along with your selected database, to ensure that the quiesce hold succeeds.
The list of unselected databases that must be quiesced are indicated in the dependency matrix.

(Optional) Click Summary to verify your selected options.
Click Finish to start the quiesce-hold process.