I know it is possible to start and stop a DB2 instance which can contain multiple databases. I was wondering is it possible to start and stop individual databases?

Also, is there a command which will tell me the status of what is running on a server.

Thanks.

The db is considered stopped (inactive/offline) when you don't see any applications connected to it in the list applications output and it's not listed in the list active databases output.

In addition to what db2girl said, you can issue explicitly start and stop selected databases by using commands.

db2 "ACTIVATE DATABASE db_name"

db2 "DEACTIVATE DATABASE db_name"


The explicit activation has some performance benefits over the implicit activation ( "CONNECT TO") method.

Cheers,
SK Chandra

Also, is there a command which will tell me the status of what is running on a server.

yes : list applications (show detail)

Thanks to all.

There needs to be a clarification on the ACTIVATE DATABASE and DEACTIVATE DATABASE commands. When you issue the ACTIVATE DATABASE command, it will start the database if is is not already started (either by a previous ACTIVATE DATABASE command or a connection to the database). It will also prevent the database from going inactive when the last connection is ended whether it started it or not. The DEACTIVATE DATABASE will only stop the database if there are no connections to it. If there are connections, the database will then deactivate when the last connection has ended.

Andy

That is why propagate a 1:1 relationship between instances & databases. If 1 database has 1 dedicated instance it is more easy to manage (db2stop/db2start).