Database deactivation with the Db2 pureScale Feature

In a Db2 pureScale environment, a database that has been explicitly activated through the ACTIVATE DATABASE command or, implicitly activated by a user connection, can only be deactivated through a DEACTIVATE DATABASE command.

Before you begin

Note: An exception to this procedure is if the database was implicitly activated by a user connection. After an online backup, if no user connections to the database exist, the database will be deactivated implicitly.
To proceed, ensure that you have one of these authorization levels:
  • SYSMAINT
  • SYSCTRL
  • SYSADM

About this task

In a Db2 pureScale environment, after the last user disconnects the database remains activated. In order to shut the database down, you must issue a DEACTIVATE DATABASE command or, db2stop command.

Procedure

  1. To deactivate a database in a Db2 pureScale environment, issue the DEACTIVATE DATABASE command which will automatically deactivate the database across all members.
  2. To deactivate the database on a specific member, issue the DEACTIVATE DATABASE command with the MEMBER parameter.

Example

Example 1
To deactivate the TEST database, run this command:
      DB2 DEACTIVATE DATABASE TEST
Example 2
To deactivate a specific member, run this command:
      DB2 DEACTIVATE DATABASE TEST MEMBER 10