DB2 Version 9.7 for Linux, UNIX, and Windows

UNQUIESCE command

Restores user access to instances or databases which have been quiesced for maintenance or other reasons.UNQUIESCE restores user access without necessitating a shutdown and database restart.

Unless specifically designated, no user except those with SYSADM, SYSMAINT, or SYSCTRL has access to a database while it is quiesced. Therefore an UNQUIESCE is required to restore general access to a quiesced database.

Scope

UNQUIESCE DB restores user access to all objects in the quiesced database.

UNQUIESCE INSTANCE instance-name restores user access to the instance and the databases in the instance instance-name.

To stop the instance and unquiesce it and all its databases, issue the db2stop command. Stopping and restarting DB2® will unquiesce all instances and databases.

Authorization

One of the following:

For database level unquiesce:

SYSADM
DBADM

For instance level unquiesce:

SYSADM
SYSCTRL

Command syntax


>>-UNQUIESCE--+-DB----------------------+----------------------><
              '-INSTANCE--instance-name-'

Required connection

Database

(Database connection is not required for an instance unquiesce.)

Command parameters

DB: Unquiesce the database. User access will be restored to all objects in the database.
INSTANCE instance-name: Access is restored to the instance instance-name and the databases in the instance.

Examples

Unquiescing a Database

db2 unquiesce db

This command will unquiesce the database that had previously been quiesced.