HADR with multiple standbys for Db2

Db2 on IBM Software Hub supports HADR with multiple standby databases. Using multiple standbys, you can have your data in more than two sites, which provides improved data protection with a single technology.

With HADR, you can have up to three standby databases in your setup. One of these databases must be designated as the principal HADR standby database; any other standby database is an auxiliary HADR standby database.

For full documentation on this configuration, see HADR multiple standby databases.

Restrictions

• Databases must be designated during configuration as primary, principal standby, and auxiliary standby. These roles cannot be changed without reconfiguration
• Automated failover with Governor is only supported between the primary and principal standby databases
• Fail over to an auxiliary standby database must be initiated manually.
• If the database was previously in an HADR standby role, it automatically starts as standby on pod restarts on the designated auxiliary databases. If it was set to the primary database due to a manually initiated failover, HADR is not automatically restarted as primary. This setup is used to prevent a split-brain scenario because Governor is not supported on the designated auxiliary.