Instance and Database Maintenance Mode: Quiesce

Abstract

Database maintenance is an on-going activity and responsibility of a DBA. From time to time, a DBA
needs to perform maintenance work on an instance or a database in an exclusive or controlled mode.
The new QUIESCE command in DB2 UDB V8 provides this capability to the DBA.

Contents


Instance and database maintenance mode: Quiesce

Database maintenance is an on-going activity and responsibility of a DBA. From time to time, a DBA
needs to perform maintenance work on an instance or a database in an exclusive or controlled mode. The new QUIESCE command in DB2 UDB V8 provides this capability to a DBA. QUIESCE a database or instance puts the instance or database in administrative mode. In this restricted mode, only users with authority can attache or connect to the instance or database.

A DBA can use this command to force all the users off the system. A DBA can also use this command to permit only a group of users to have exclusive use of the databases under an instance. This is a powerful and useful command for database administrators. For example:

DB2 QUIESCE db2inst1 GROUP acctgrp IMMEDIATE FORCE CONNECTIONS;

This will force all the connections to the database under instance db2inst1 except those users in group acctgrp. The user in acctgrp can keep accessing the database.

To remove the quiesce mode, use the UNQUIESCE command; for example:
DB2 UNQUIESCE db2inst1;

Special Notices

This material has not been submitted to any formal IBM test and is published AS IS. It has not been the subject of rigorous review. IBM assumes no responsibility for its accuracy or completeness. The use of this information or the implementation of any of these techniques is a client responsibility and depends upon the client's ability to evaluate and integrate them into the client's operational environment. publib-b.boulder.ibm.com

Profile

Publish Date
14 December 2003


Rating:
(based on 1 review)


Author(s)

IBM Form Number
TIPS0342