DB2 HADR - activate | deactivate

 We disabled HADR on host CDPLVM8BAWDB for all 5 databases. We were able to start the databases as standalone.


Warning: Although the STOP HADR command can be used to stop HADR on the primary or the standby, or both, it should be used with caution. If you want to stop the specified database but still want it to maintain its role as either an HADR primary or a standby database, do not issue the STOP HADR command. If you issue the STOP HADR command, the database becomes a standard database and might require reinitialization in order to resume operations as an HADR database. Instead, issue the DEACTIVATE DATABASE command.


If you only want to shut down the HADR operation, this is the recommended way of shutting down the HADR pair:

  1. Deactivate the primary database
  2. Stop Db2 on the primary database
  3. Deactivate the standby database
  4. Stop Db2 on the standby database



You may please refer following documents for


1) Stopping Db2 High Availability Disaster Recovery (HADR)

https://www.ibm.com/docs/en/db2/11.5.x?topic=maintenance-stopping-hadr


2) Database activation and deactivation in a high availability disaster recovery (HADR) environment

https://www.ibm.com/docs/en/db2/11.5.x?topic=maintenance-hadr-database-activation-deactivation

Post a Comment

Previous Post Next Post