IBM Support

Steps to reboot Db2 HADR configured servers

Technical Blog Post


Abstract

Steps to reboot Db2 HADR configured servers

Body

If you plan to reboot both the systems:


0. Stop your applications completely.
1. db2 force applications all (on primary)
2. db2 deactivate db database_name(on primary)
3. db2 deactivate db database_name(on standby)
4. db2stop force (on both systems)
5. Reboot your systems

After systems are restarted:

1. db2start (on both systems)
2. db2 activate db database_name(on standby)
3. db2 activate db database_name(on primary)
4. Start your applications.

 


 

In case you wish you to reboot only one system:

1. Please make sure that the system you want to reboot is standby at that moment. If it is primary, then do takeover as follows:
1a. db2 takeover hadr on db database_name
2. db2 deactivate db database_name(on standby - system which will be rebooted)
3. db2stop force (on standby)

After system is restarted:

1. db2start (on standby)
2. db2 activate db database_name(on standby)

 


Disclaimer: These steps are applicable to Db2 HADR systems only (which are not configured with TSA).

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

UID

ibm13285783