Forces all users off the specified instance and database and puts it into a quiesced mode.
While the database is in quiesced mode, you can perform administrative tasks on it. After administrative tasks are complete, use the UNQUIESCE command to activate the database and allow other users to connect to the database without having to shut down and perform another database start.
In this mode, only users with authority in this restricted mode are allowed to connect to the database. Users with SYSADM and DBADM authority always have access to a database while it is quiesced.
QUIESCE DATABASE results in all objects in the database being in the quiesced mode. Only the allowed user or group and SYSADM, SYSMAINT, DBADM, or SYSCTRL will be able to access the database or its objects.
One of the following:
For database level quiesce:
Database
>>-QUIESCE--+-DATABASE-+----------------------------------------> '-DB-------' >--+-IMMEDIATE------------------------+-------------------------> '-DEFER--+-----------------------+-' '-WITH TIMEOUT--minutes-' .-FORCE CONNECTIONS-. >--+-------------------+---------------------------------------><
CALL SYSPROC.ADMIN_CMD( 'quiesce db immediate' )
For example,
grant quiesce_connect on database to username/groupname
revoke quiesce_connect on database from username/groupname