Database activation with the Db2 pureScale Feature

A database in a Db2 pureScale® environment can be activated explicitly with the ACTIVATE DATABASE command, or implicitly when the first client connects.

Before you begin

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

To activate a database in a Db2 pureScale environment, issue the ACTIVATE DATABASE command which will automatically activate the database across all members.

Example

To activate the TEST database across all members, run the command:
      DB2 ACTIVATE DATABASE TEST