By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

staring and stoping a database in DB2

P: n/a
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.

Apr 26 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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

Apr 26 '06 #2

P: n/a
Thanks Kiran. Any idea how to do it in the control center. I using DB2
8.2 on windows.

regards,
Baski.

Apr 26 '06 #3

P: n/a
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


Apr 26 '06 #4

P: n/a
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" <ma*********@gmail.com> a écrit dans le message de news:
11*********************@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.


Apr 27 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.