Digital Developer Conference: a FREE half-day online conference focused on AI & Cloud – North America: Nov 2 – India: Nov 9 – Europe: Nov 14 – Asia Nov 23 Register now

Close outline
  • United States
IBM?
  • Site map
IBM?
  • Marketplace

  • Close
    Search
  • Sign in
    • Sign in
    • Register
  • IBM Navigation
IBM Developer Answers
  • Spaces
    • Blockchain
    • IBM Cloud platform
    • Internet of Things
    • Predictive Analytics
    • Watson
    • See all spaces
  • Tags
  • Users
  • Badges
  • FAQ
  • Help
Close

Name

Community

  • Learn
  • Develop
  • Connect

Discover IBM

  • ConnectMarketplace
  • Products
  • Services
  • Industries
  • Careers
  • Partners
  • Support
10.190.13.195

Refine your search by using the following advanced search options.

Criteria Usage
Questions with keyword1 or keyword2 keyword1 keyword2
Questions with a mandatory word, e.g. keyword2 keyword1 +keyword2
Questions excluding a word, e.g. keyword2 keyword1 -keyword2
Questions with keyword(s) and a specific tag keyword1 [tag1]
Questions with keyword(s) and either of two or more specific tags keyword1 [tag1] [tag2]
To search for all posts by a user or all posts with a specific tag, start typing and choose from the suggestion list. Do not use a plus or minus sign with a tag, e.g., +[tag1].
  • Ask a question

Using db2haicu -delete does not remove my cluster resources nor reset cluster_mgr to null.

110000GGFH gravatar image
Question by Clark Jackson  (4396) | Jul 22, 2015 at 11:24 AM nsatsamptsadb2haicu

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.


ITNMPaul
Gareth Holl

People who like this

  2
Comment
10 |3000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster

1 reply

  • Sort: 
110000GGFH gravatar image
Accepted answer

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:

How to manually assign or remove a virtual IP address when TSAMP is in Manual mode or the domain is offline

Comment
ITNMPaul
Gareth Holl

People who like this

  2   Share
10 |3000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster

Follow this question

38 people are following this question.

Answers

Answers & comments

Related questions

When I upgrade DB2 from 9.7/10.1 to 10.5/11.1 with TSAMP automated cluster, do I need to db2haicu -delete the cluster and rebuild? 1 Answer

What are the basic steps needed to install a DB2 fixpack when there is a configured TSAMP/RSCT cluster? 1 Answer

db2haicu libct_mc.so problem for Linux on PPC 64 bit 3 Answers

DB2 10.5.0.3 - TSAMP installation fails on Red Hat 7.1 3 Answers

Why can't I add my HADR DB to the cluster using db2haicu? 1 Answer

  • Contact
  • Privacy
  • IBM Developer Terms of use
  • Accessibility
  • Report Abuse
  • Cookie Preferences

Powered by AnswerHub

Authentication check. Please ignore.
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • API Connect
  • Analytic Hybrid Cloud Core
  • Application Performance Management
  • Appsecdev
  • BPM
  • Blockchain
  • Business Transaction Intelligence
  • CAPI
  • CAPI SNAP
  • CICS
  • Cloud Analytics
  • Cloud Automation
  • Cloud Object Storage
  • Cloud marketplace
  • Collaboration
  • Content Services (ECM)
  • Continuous Testing
  • Courses
  • Customer Experience Analytics
  • DB2 LUW
  • Data and AI
  • DataPower
  • Decision Optimization
  • DevOps Build
  • DevOps Services
  • Developers IBM MX
  • Digital Commerce
  • Digital Experience
  • Finance
  • Global Entrepreneur Program
  • Hadoop
  • Hybrid Cloud Core
  • Hyper Protect
  • IBM Cloud platform
  • IBM Design
  • IBM Forms Experience Builder
  • IBM Maximo Developer
  • IBM StoredIQ
  • IBM StoredIQ-Cartridges
  • IIDR
  • ITOA
  • InformationServer
  • Integration Bus
  • Internet of Things
  • Kenexa
  • Linux on Power
  • LinuxONE
  • MDM
  • Mainframe
  • Messaging
  • Node.js
  • ODM
  • Open
  • PartnerWorld Developer Support
  • PowerAI
  • PowerVC
  • Predictive Analytics
  • Product Insights
  • PureData for Analytics
  • Push
  • QRadar App Development
  • Run Book Automation
  • Search Insights
  • Security Core
  • Storage
  • Storage Core
  • Streamsdev
  • Supply Chain Business Network
  • Supply Chain Insights
  • Swift
  • UBX Capture
  • Universal Behavior Exchange
  • UrbanCode
  • WASdev
  • WSRR
  • Watson
  • Watson Campaign Automation
  • Watson Content Hub
  • Watson Marketing Insights
  • dW Answers Help
  • dW Premium
  • developerWorks Sandbox
  • developerWorks Team
  • Watson Health
  • More
  • Tags
  • Questions
  • Users
  • Badges