Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

When using Microsoft SQL Server, there is this handy thing called dedicated administrator connection. You can tell the database to drop all connections and not open any new ones, but keep the one you use right now alive for administrative purposes.

Is there a similar feature available for IBM's DB2 UDB?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

There are a few options:

  1. QUIESCE INSTANCE command
  2. QUIESCE DATABASE command
  3. CONNECT TO DATABASE IN EXCLUSIVE MODE statement

Quiescing optionally allows you to kill all other connections to the instance (which could apply to multiple databases) or to a single database; but this will not prevent users who have appropriate privileges to reconnect.

Connecting to a database in exclusive mode will allow multiple connections from the same user. You will have to manually kill other user connections first, though.

share|improve this answer
    
Aha, IN EXCLUSIVE MODE seems to be a good thing! Thanks. –  Tim Büthe Apr 20 '10 at 10:34

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.