Prerequisites for configuring HADR for the Db2 Warehouse service

Before configuring 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 Cloud Pak for Data, 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 will operate as the primary and standby databases. Use the same database name for all of the deployed databases that you will 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.