Replacing a Pacemaker-managed Db2 DPF Roving Standby HA instance with a Tivoli SA MP-managed Db2 instance

If you are running Db2 on a DPF-configured Linux cluster that is managed by Pacemaker, you can use the db2cm utility to replace cluster management with IBM Tivoli System Automation for Multiplatforms (SA MP).

About this task

Important: Starting from Db2® 12.1, DPF high availability is supported when using Pacemaker as the integrated cluster manager. The Pacemaker cluster manager is packaged and installed with Db2.
Take note of the following information before you start your conversion:
  • Db2 clients can be disconnected during this operation if the original cluster is configured to use a virtual IP address (VIP).
  • The Db2 DPF hosts remain online throughout the operation but the automated failover in the Db2 DPF Pacemaker cluster is disabled during the conversion.
  • When running db2cm, ensure that you run the command as the root user.
The following placeholders are used in the command statements throughout this procedure:
  • <exportedFile> is the name of the file to which the instance owner backs up their existing SA MP cluster configuration.
  • <resourceModel> is the name of the Pacemaker resource model that you back up before proceeding with the conversion.
Note: The following procedure assumes an in-version conversion, which means that there is no change in the Db2 version.

Procedure

  1. Back up the current Pacemaker resource model, so that it is available for future use: 
    cp /var/lib/pacemaker/cib/cib.xml $HOME/<resourceModel>.xml
  2. Delete the current Pacemaker resources and cluster: 
    INSTANCE_HOME/sqllib/bin/db2cm -delete -domain <domain name>
  3. Create the Tivoli SA MP resource model:
    • If a backup of a previous Tivoli SA MP configuration is to be restored using a db2haicu XML file, run the following command first on the standby instance and then on the primary instance: 
      db2haicu -f exportedFile.xml
    • To create the resource model from scratch, run the db2haicu on the standby instance and follow the on-screen instructions.