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