staring and stoping a database in DB2

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Baski - 26 Apr 2006 13:26 GMT

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.

Reply to this Message

Kiran Nair - 26 Apr 2006 13:34 GMT

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

Reply to this Message

Baski - 26 Apr 2006 13:58 GMT

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

regards,
Baski.

Reply to this Message

Pierre Saint-Jacques - 27 Apr 2006 03:49 GMT

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.

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

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

Reply to this Message

Norbert Munkel - 26 Apr 2006 13:58 GMT

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/infocenter/db2luw/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

Reply to this Message