Kiran Nair schrieb:
> Hi Baski,
>
> DB2 can have multiple databases in one instance.
> For starting or stoping specific database inside DB2 we need to use
> ACTIVATE/DEACTIVATE DATABASE

We should mention that any DB2-Database will be implicitly activated by
the first connection. See

http://publib.boulder.ibm.com/infoce.../v8//index.jsp

and look for "ACTIVATE DATABASE".

But that does not seem to be the issue here. It would be interesting to
know what
effects are expected by O-DBAs if they talk about "stopping a database".
Is it closing down all resources and protect the database from any
connection attempts (even from priviledged users) ? IMHO this would
only work by shutting down the instance (AFAIR, in O: instance=database).

If he needs something like "force all (user)-Applications off and let me
still do my DBA-Tasks", I would encourage him to have a look at the
"QUIESCE DATABASE"-Command.

regards,

Norbert