Db2's db2diag.log shows this error message:
2015-07-17-20.20.07.965676+000 E51997E690 LEVEL: Error
PID : 17162 TID : 140290072880928 PROC : db2haicu
INSTANCE: dbinst1 NODE : 000
HOSTNAME: node11
FUNCTION: DB2 UDB, high avail services, sqlhaGetParentResourceGroup2, probe:300
MESSAGE : ECF=0x90000552=-1879046830=ECF_SQLHA_OBJECT_DOES_NOT_EXIST
Cluster object does not exist
DATA #1 : String, 35 bytes
Error during vendor call invocation
DATA #2 : unsigned integer, 4 bytes
23
DATA #3 : String, 22 bytes
db2ip_10_10_10_175-rs
DATA #4 : unsigned integer, 8 bytes
1
DATA #5 : signed integer, 4 bytes
262152
DATA #6 : String, 46 bytes
Line # : 15656---2610-407 No resources found.
Answer by Clark Jackson (4396) | Jul 22, 2015 at 11:43 AM
The issue here is shown by two specific bits of information from the error message:
FUNCTION: DB2 UDB, high avail services, sqlhaGetParentResourceGroup2, probe:300
and
Line # : 15656---2610-407 No resources found.
So in this case db2haicu was looking for the parent resource group for the IBM.ServiceIP resource db2ip_10_10_10_175-rs and was not finding it. It found the IBM.ServiceIP but could not find the resource group that the SIP belonged to which means that the SIP was unmanaged.
When db2haicu goes to delete an instances configured clustered resources it lists all IBM.ServiceIP's and attempts to ensure that they do or do not belong to the resource group of the instance being removed. In this case it found a resource that could not be tied to a group and this stopped db2haicu from carrying out the rest of the deletion.
To resolve this you should manually remove the db2ip resource from the cluster because since the resource is not contained in a resource group it is not being managed/automated by TSAMP anyway so has no use in the cluster.
To manually remove the above shown IBM.ServiceIP resource use the following:
export CT_MANAGEMENT_SCOPE=2
rmrsrc -s 'Name ="db2ip_10_10_10_175-rs"' IBM.ServiceIP Force=1
The above command will remove the IBM.ServiceIP resource even if it is online but will not take the alias offline (tested on AIX 7.1 only).
If you need to manually assign or remove an IP Address alias please see the following knowledge article: