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.