DB2 FOR LUW / DB2FORLUW / A10 - DB2

If you have a DB2 HADR/TSA setup, and you look to use the 
db2haicu maintenance mode option to move the HADR primary 
database over to the standby node, i.e. option 5 from the below 
db2haicu maintenance mode menu: 
 
$ db2haicu 
(...) 
 
Select an administrative task by number from the list below: 
  1. Add or remove cluster nodes. 
  2. Add or remove a network interface. 
  3. Add or remove HADR databases. 
  4. Add or remove an IP address. 
  5. Move DB2 database partitions and HADR databases for 
scheduled maintenance. 
  6. Create a new quorum device for the domain. 
  7. Destroy the domain. 
  8. Exit. 
 
Then it is possible that the HADR resource group remains locked 
after the move request has successfully completed. The lock 
state of the HADR resource group can be viewed via the lssam 
command output: 
 
Online IBM.ResourceGroup:db2_db2inst1_host03_0-rg Nominal=Online 
        '- Online IBM.Application:db2_db2inst1_host03_0-rs 
                '- Online 
IBM.Application:db2_db2inst1_host03_0-rs:host03 
Online IBM.ResourceGroup:db2_db2inst1_host04_0-rg Nominal=Online 
        '- Online IBM.Application:db2_db2inst1_host04_0-rs 
                '- Online 
IBM.Application:db2_db2inst1_host04_0-rs:host04 
Online IBM.ResourceGroup:db2_db2inst1_db2inst1_DBHADR-rg 
Request=Lock Nominal=Online 
        '- Online 
IBM.Application:db2_db2inst1_db2inst1_DBHADR-rs 
Control=SuspendedPropagated 
                |- Online 
IBM.Application:db2_db2inst1_db2inst1_DBHADR-rs:host03 
                '- Offline 
IBM.Application:db2_db2inst1_db2inst1_DBHADR-rs:host04 
Online IBM.Equivalency:db2_db2inst1_host03_0-rg_group-equ 
        '- Online IBM.PeerNode:host03:host03 
Online IBM.Equivalency:db2_db2inst1_host04_0-rg_group-equ 
        '- Online IBM.PeerNode:host04:host04 
Online IBM.Equivalency:db2_db2inst1_db2inst1_DBHADR-rg_group-equ 
        |- Online IBM.PeerNode:host03:host03 
        '- Online IBM.PeerNode:host04:host04 
Online IBM.Equivalency:db2_public_network_0 
        |- Online IBM.NetworkInterface:eth1:host04 
        '- Online IBM.NetworkInterface:eth0:host03 
 
As seen from the above lssam output, there is a lock request 
placed on the HADR resource group 
"db2_db2inst1_db2inst1_DBHADR-rg". If this is the case, and it 
is determined that the HADR database pair is in primary-standby 
peer state, then this lock has been erroneously placed on the 
HADR resource group and should be removed.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW v10.1 Fixpack 5 or Later.                 * 
****************************************************************

Unlock the resource group by issuing the following TSA command 
as root: 
"rgreq -o unlock <Resource Group>"

First Fixed in DB2 LUW v10.1 Fixpack 5.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

28.08.2014
13.07.2015
13.07.2015