How to Stop a Database

[yerim y via DBMonster.com]

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

[Knut Stolze]

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

[Gert van der Kooij]

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.

[yerim y via DBMonster.com]

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