Skip to content


Did you know that since version 8 the QUIESCE command has allowed you to block new connections for  either the entire DB2 instance (and all databases under it) or to just quiesce a single database? You do this using the INSTANCE and DATABASE options.

You can also quiesce an instance or database, yet make exceptions to allow connections from specific users and groups, using the USER and GROUP options. You could use this, for example, to allow a production application to continue processing under its GROUP or USER authority, yet block ad hoc queries from business users. More useful yet is the ability to allow users with less than SYSADM/DBADM/SYSCTRL authority do maintenance on tables while excluding all other connections and workloads.

You can also allow applications to complete their current transaction by using the DEFER option, or allow them up to a specified period of time to complete (general default of 10 minutes) by using DEFER WITH TIMEOUT.

These options are documented here for:

One Comment

  1. Kavita

    I have Full time positions for DB2 DBA’s Rhode Island RI. RBS Citizens is a national bank and is a member of The Royal Bank of Scotland Group (RBS Group), one of the world’s leading financial services companies. .

    Please take a look at our website and the job description attached. Our website is
    Let me know how I can get access to your Data base or distribute this email to all the DBA in RI.

    If you have any questions email me @

    Thank you and have a great day.

    Posted on 19-Feb-09 at 08:56 | Permalink

Post a Comment

Your email is never published nor shared. Required fields are marked *