Command Reference

DEACTIVATE DATABASE

Stops the specified database.

Scope

In an MPP system, this command deactivates the specified database on all nodes in the system. If one or more of these nodes encounters an error, a warning is returned. The database will be successfully deactivated on some nodes, but may remain activated on the nodes encountering the error.

Authorization

One of the following:

sysadm
sysctrl
sysmaint

Required Connection

None

Command Syntax

>>-DEACTIVATE--+-DATABASE-+---database-alias-------------------->
               '-DB-------'
 
>-----+---------------------------------------+----------------><
      '-USER--username--+------------------+--'
                        '-USING--password--'

Command Parameters

DATABASE database-alias: Specifies the alias of the database to be stopped.
USER username: Specifies the user stopping the database.
USING password: Specifies the password for the user ID.

Usage Notes

Databases initialized by ACTIVATE DATABASE can be shut down by DEACTIVATE DATABASE or by db2stop. If a database was initialized by ACTIVATE DATABASE, the last application disconnecting from the database will not shut down the database, and DEACTIVATE DATABASE must be used. (In this case, db2stop will also shut down the database.)
Note: The application issuing the DEACTIVATE DATABASE command cannot have an active database connection to any database.

See Also

ACTIVATE DATABASE

STOP DATABASE MANAGER.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]