Restores user access to 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.
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.
One of the following:
For database level unquiesce:
Database
Unquiescing a Database
CALL SYSPROC.ADMIN_CMD( 'unquiesce db' )
This command will unquiesce the database that had previously been quiesced.
Command execution status is returned in the SQLCA resulting from the CALL statement.