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

How to Stop a Database

P: n/a

hello,

I am trying to stop a databse, have it in a read only mode. What i have found
so far is the DB2STOP but that command works at he instance level, stopping
all databases. Anybody knows of a command to stop a single database?
Thanks
--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....m-db2/200507/1
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
yerim y via DBMonster.com wrote:

hello,

I am trying to stop a databse, have it in a read only mode. What i have
found so far is the DB2STOP but that command works at he instance level,
stopping all databases. Anybody knows of a command to stop a single
database? Thanks


If the database was activated explicitly, run the DEACTIVATE DATABASE
command and terminate all connections with FORCE APPLICATION. If the
database was activated implicitly by the first connect, just terminate all
connections.

--
Knut Stolze
Information Integration Development
IBM Germany / University of Jena
Nov 12 '05 #2

P: n/a
In article <db**********@fsuj29.rz.uni-jena.de>, Knut Stolze
(st****@de.ibm.com) says...
yerim y via DBMonster.com wrote:

hello,

I am trying to stop a databse, have it in a read only mode. What i have
found so far is the DB2STOP but that command works at he instance level,
stopping all databases. Anybody knows of a command to stop a single
database? Thanks


If the database was activated explicitly, run the DEACTIVATE DATABASE
command and terminate all connections with FORCE APPLICATION. If the
database was activated implicitly by the first connect, just terminate all
connections.


I guess the second part of the question can't be solved by this. As
far as I know it's not possible to set a database in read-only mode.
Nov 12 '05 #3

P: n/a

Knut Stolze wrote:
If the database was activated explicitly, run the DEACTIVATE DATABASE
command and terminate all connections with FORCE APPLICATION. If the
database was activated implicitly by the first connect, just terminate all
connections.


Thanks, Knut. the diactivate did it.

Gert van der Kooij, comming from SQL Server i tend to use their terminology.
But you get the idea. Thanks
--
Message posted via http://www.dbmonster.com
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.