UNQUIESCE DATABASE command using the ADMIN_CMD procedure

Restores user access to 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.

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

Command syntax

Read syntax diagramSkip visual syntax diagramUNQUIESCEDB

Required connection

Database

Command parameters

DB
Unquiesce the database. User access will be restored to all objects in the database.

Example : Unquiescing a database

The following command unquiesces the database that had previously been quiesced.

CALL SYSPROC.ADMIN_CMD( 'unquiesce db' )

The following command will unquiesce the instance instA that had previously been quiesced.

db2 unquiesce instance instA

Usage notes

  • Command execution status is returned in the SQLCA resulting from the CALL statement.
  • 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.