Prerequisites for configuring HADR for the Db2 Warehouse service

Before you configure HADR for the Db2 Warehouse service, you must deploy two or more databases and set the same password for primary and standby deployments.

Restriction: Only SMP deployments on Db2 Warehouse can be configured to use HADR.

Before you set up a Db2 Warehouse HADR configuration on IBM Software Hub, be sure that you do the following tasks:

  • Install and deploy two or more Db2 Warehouse database deployments that are at the same release level. These deployments operate as the primary and standby databases. Use the same database name for all of the deployed databases that you use in the Db2 Warehouse HADR configuration.
  • Ensure that the primary and the standby deployments have the same password. See Updating the Db2 Warehouse password secrets for details on updating passwords for the Db2 Warehouse deployments.
  • Ensure the database configuration value for LOGARCHMETH1 is not set to OFF.