Question & Answer
Question
What is difference between explicit activation and implicit activation of a DB2 database?
Answer
There are two ways to activate a DB2 database:
1) Explicit activation
db2 "activate database <dbname>"
This command activates the specified database on all nodes within the system.
2) Implicit activation
db2 "connect to <dbname>"
The first connection to the database activates the database.
If database was activated implicitly, i.e. activated via first connection, then the database will be deactivated automatically after all the connections are terminated. On the other hand, if a database was explicitly activated, it will need to be explicitly deactivated by using "deactivate DB <dbname>" command.
If a database need to be activated in advance, for example when there are automatic maintenance jobs, such as automatic backup/automatic reorg, etc are scheduled in the database, database should be activated during the maintenance window and explicit activation is preferred.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21673507