Activating a database after upgrade

Activating your database allows you to ensure that all database services are running properly and to address any problems that might occur during the database activation. You can also eliminate the overhead on Db2® clients that have to wait until the database manager starts up the database to get a connection to this database.

Before you begin

Ensure that you have SYSMAINT, SYSCTRL, or SYSADM authority.


To activate your databases after upgrade:

  1. Start your database and all necessary database services with the ACTIVATE DATABASE command.
    The following example illustrates the use of this command to activate the sample database:
       db2 ACTIVATE DATABASE sample
    After this command is executed successfully your database is available for connections.
  2. Review the administration notification log or the db2diag log files to verify that all database services are running properly and all buffer pools are activated. Address any problems that occurred during the database activation.


Remember that a database, activated by the ACTIVATE DATABASE command, stops only when you issue the DEACTIVATE DATABASE command or the db2stop command. If the database is activated when the first connection is established, then the database is stopped when the last connection is closed.