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:

<host1> is the host name that is to be assigned a VIP within the Mutual Failover Db2 instance.

Procedure

As the root user, remove the VIP for the primary host in 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