E-mail : support@tech2now.in

How to start HA DR on DB2 database

Db2 Database
  1. Deactivate HADR on standby DB

$db2 deactivate db RTC
DB20000I The DEACTIVATE DATABASE command completed successfully

  1. Stop HADR on standby database

$db2 STOP HADR ON DB RTC
DB20000I The STOP HADR ON DATABASE command was completed successfully.

  1. Deactivate HADR on the Primary database

$db2 deactivate db RTC
DB20000I The DEACTIVATE DATABASE command was completed successfully

  1. Stop HADR on the Primary database

$db2 stop HADR on database RTC as primary
DB20000I The STOP HADR ON DATABASE command was completed successfully.

Steps to START HADR DB2 database

  1. Start HADR on the standby database

$db2 START HADR ON DB RTC AS STANDBY
DB20000I The START HADR ON DATABASE command was completed successfully.

$db2 activate db RTC
DB20000I The DEACTIVATE DATABASE command was completed successfully

Run the same steps primary database as well

  1. Start HADR on the Primary database:

db2 start HADR on database RTC as primary
DB20000I The START HADR ON DATABASE command was completed successfully.

$db2 activate db RTC
DB20000I The DEACTIVATE DATABASE command was completed successfully