db2 takeover hadr on database xxxxxx
SQL1387W A DB2 High Availability Disaster Recovery (HADR) takeover completed successfully. However, a HADR resource group remains locked; and the cluster manager is not controlling that resource group.
Fix:
unlock with root
rgreq -o unlock db2_instpref_instpref_CTMPREF-rg
stoprpdomain xxxxxx
2632-110 The operation was rejected by one or more nodes, probably because one or more resources are online or there was an error encountered in determining if any resources are online.
g01acirdbha012: 2632-054 The requested operation failed due to the rejection from the resource class IBM.CHARMControl.
Message returned from the resource class: 2621-793 Node "g01acirdbha013" cannot be made offline. System Automation Manager reports that there are resources online on this node..
Fix:
chrg -o offline db2_db2bcu_14-rg
stoprpdomain xxxxxx
1. Migrate the TSA domain:
root@grom04:# export CT_MANAGEMENT_SCOPE=2
root@grom04:# runact -c IBM.PeerDomain CompleteMigration Options=0
Resource Class Action Response for CompleteMigration
root@grom04:# samctrl -m
Ready to Migrate! Are you Sure? [Y|N]:.
Y
2. Ensure that MixedVersions is no longer set to Yes for the cluster component:
root@grom04:# lsrpdomain
Name OpState RSCTActiveVersion MixedVersions TSPort GSPort
----- -------- ------------------ -------------- ------- -------
test Online 2.5.3.5 No 12347 12348
3. Ensure that the active version number (AVN) matches the installed version number (IVN) for the HA manager:
root@grom04:# lssrc -ls IBM.RecoveryRM |grep VN
Our IVN : 2.2.0.7
Our AVN : 2.2.0.7