Disassociating a Virtual IP from a DPF Db2 instance

You can disassociate a virtual IP address (VIP) from a DPF Db2 instance by using the Db2 Cluster Manager (db2cm) utility.

About this task

The following placeholder is used in the command statements throughout this procedure. It represent a value that you can change to suit your organization:

<partition_number> is the number assigned to the target partition on the cluster.

Procedure

As the root user, remove the VIP for the partition on its host in the current domain of the Db2 instance:
```
[root@host1]# db2cm -delete -primaryVIP -partition <partition_mumber>
```
As the root user, verify that the resource has been deleted successfully:
```
[root@host1]# db2cm -list
```

Example

The following example shows the command syntax and output from disassociating a VIP from a the Db2 instance:

[root@host1]# db2cm -delete -primaryVIP -partition 0
Primary VIP resource deleted successfully.

The following example shows the command syntax and output from verifying that the VIP resource is removed from the Db2 instance:

[root@host1]# db2cm -list

HA Model: DPF Roving Standby

Domain Information:
Domain name                     = hadomain
Cluster Manager                 = Corosync
  Cluster Manager Version       = 3.1.7
Resource Manager                = Pacemaker
  Resource Manager Version      = 2.1.6-4.db2pcmk.el9
Current domain leader           = dpf-srv-2
Number of nodes                 = 4
Number of resources             = 7

Host Information:
HOSTNAME                        STATE           MAXIMUM PARTITIONS              NUMBER OF PARTITIONS
------------------------        --------        ------------------------        --------------------------
dpf-srv-1                       ONLINE          1                               1
dpf-srv-2                       ONLINE          1                               1
dpf-srv-3                       ONLINE          1                               1
dpf-srv-4                       ONLINE          1                               0

Fencing Information:
Fencing Configured: Configured
Fencing Devices:
----------------
watchdog

Quorum Information:
Quorum Type: Majority
Total Votes: 4
Quorum Votes: 3
Quorum Nodes:
----------------
dpf-srv-1
dpf-srv-2
dpf-srv-3
dpf-srv-4

Resource Information:
Resource Name             = db2_ethmonitor_dpf-srv-1_eth0
  State                         = Online
  Managed                       = True
  Resource Type                 = Network Interface
    Node                        = dpf-srv-1
    Interface Name              = eth0

Resource Name             = db2_ethmonitor_dpf-srv-2_eth0
  State                         = Online
  Managed                       = True
  Resource Type                 = Network Interface
    Node                        = dpf-srv-2
    Interface Name              = eth0

Resource Name             = db2_ethmonitor_dpf-srv-3_eth0
  State                         = Online
  Managed                       = True
  Resource Type                 = Network Interface
    Node                        = dpf-srv-3
    Interface Name              = eth0

Resource Name             = db2_ethmonitor_dpf-srv-4_eth0
  State                         = Online
  Managed                       = True
  Resource Type                 = Network Interface
    Node                        = dpf-srv-4
    Interface Name              = eth0

Resource Name             = db2_partition_db2inst1_0
  State                         = Online
  Managed                       = True
  Resource Type                 = Partition
    Instance                    = db2inst1
    Partition Number            = 0
  Current Host                  = dpf-srv-1

Resource Name             = db2_partition_db2inst1_1
  State                         = Online
  Managed                       = True
  Resource Type                 = Partition
    Instance                    = db2inst1
    Partition Number            = 1
  Current Host                  = dpf-srv-2

Resource Name             = db2_partition_db2inst1_2
  State                         = Online
  Managed                       = True
  Resource Type                 = Partition
    Instance                    = db2inst1
    Partition Number            = 2
  Current Host                  = dpf-srv-3