UNQUIESCE command
The UNQUIESCE command restores user access to instances or databases which have been quiesced for maintenance or other reasons. The UNQUIESCE command restores user access without necessitating a shutdown and database restart.
Scope
UNQUIESCE DB restores user access to all objects in the quiesced database.
UNQUIESCE INSTANCE instance-name restores user access to the instance and all 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 authorities:
For database level unquiesce:
- SYSADM
- DBADM
- SYSADM
- SYSCTRL
Command syntax
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 all databases in the instance.
Example : Unquiescing a database
The following command unquiesces the database that had previously been quiesced.
db2 unquiesce db
Unquiescing an instance
The following command will unquiesce the instance instA
that had previously been
quiesced.
db2 unquiesce instance instA
Usage notes
- In a Db2 pureScale® environment, after quiescing a database and restarting the instance, the database will remain quiesced across all members. An explicit UNQUIESCE DATABASE command is required to remove the quiesce state.
- In a Db2 pureScale environment, after quiescing an instance and restarting the instance, the instance will remain quiesced across all members. An explicit UNQUIESCE INSTANCE command is required to remove the quiesce state.