468,321 Members | 1,639 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,321 developers. It's quick & easy.

staring and stoping a database in DB2

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
4 2095
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
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
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
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.

Similar topics

reply views Thread by Cherrish Vaidiyan | last post: by
8 posts views Thread by Kamlesh | last post: by
1 post views Thread by pintur | last post: by
8 posts views Thread by Inspector | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.