How to start and stop HADR in Maximo db2 database

Start and stop HADR DB2 database

Here are the steps to STOP HADR DB2 database:

-------------------------------------------------

1. Deactivate HADR on standby database:

db2 deactivate db MAXDB76

DB20000I  The DEACTIVATE DATABASE command completed successfully.

2. Stop HADR on standby database:

db2 STOP HADR ON DB MAXDB76

DB20000I  The STOP HADR ON DATABASE command completed successfully.

Similar scripts you would need to run on primary database as well:

1. Deactivate HADR on Primary  database:

db2 deactivate db MAXDB76

DB20000I  The DEACTIVATE DATABASE command completed successfully

2. Stop HADR on Primary database:

db2 stop HADR on database MAXDB76 as primary

DB20000I  The STOP HADR ON DATABASE command completed successfully.

Here are the steps to START HADR DB2 database:

-------------------------------------------------   

      

1. Start HADR on the standby database:

      

 db2 START HADR ON DB MAXDB76 AS STANDBY

 DB20000I  The START HADR ON DATABASE command completed successfully.

Similar scripts you would need to run on primary database as well:

1. Activate HADR on Primary database:

db2 activate db MAXDB76

DB20000I  The ACTIVATE DATABASE command completed successfully.

2. Start HADR on Primary database:

db2 start HADR on database MAXDB76 as primary

DB20000I  The START HADR ON DATABASE command completed successfully.