Activate & Deactivate DB2 Database

ACTIVATE DATABASE command

Activates the specified database and starts up all necessary database services, so that the database is available for connection and use by any application. This command activates the specified database on all nodes within the system. If one or more of these nodes encounters an error during activation of the database, a warning is returned. The database remains activated on all nodes on which the command has succeeded.

db2 activate db

DEACTIVATE DATABASE Command

Stops the specified database. This command deactivates the specified database on all database partitions in the system. If one or more of these database partitions encounters an error, a warning is returned. The database will be successfully deactivated on some database partitions, but might continue to be active on the nodes encountering the error.

db2 deactivate db

You May Also Like

Leave a Reply?