Hi,

In DB2 is it possible to start and stop a single database as it is done
in oracle, or only instances can be started and stopped??? When I try
to stop/start a database in the control center all the databases in the
instance gets stopped/started. The user with which I try to stop/start
has the instance level privelages.

regards,
Baski.

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

Regards,
Kiran Nair

Thanks Kiran. Any idea how to do it in the control center. I using DB2
8.2 on windows.

regards,
Baski.

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

You can't DEACTIVATE from the Control Center (and I don't know why !!!)

As mentioned in another post to answer you, if you need to have no one
connected so that you can do your work in peace, then look at the QUIESCE
command.

HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Baski" <mailtobaski@gmail.com> a écrit dans le message de news:
1146056290.663205.33060@j33g2000cwa.googlegroups.c om...
> Thanks Kiran. Any idea how to do it in the control center. I using DB2
> 8.2 on windows.
>
> regards,
> Baski.
>