IBM Support

IV73358: THE 'DB2CLUSTER -CM -DELETE -RESOURCES' COMMAND MAY FAIL IF A HOSTNAME CONTAINS THE 'CF' OR 'MEMBER' SUBSTRING

Fixes are available

DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 10 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 11 for Linux, UNIX, and Windows

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Deleting cluster manager resources fails with the following
error:

$ db2cluster -cm -delete -resources
A db2nodes.cfg entry does not match the corresponding entry in
the HA registry. HA  Registry: '128 TESTCF01 0 cf1-0,cf1-1 -
CF' db2nodes.cfg: '128 TESTCF01 0 cf1-0,cf1-1 - CF'. Compare
the contents db2nodes.cfg and the output of db2hareg -dump
A db2nodes.cfg entry does not match the corresponding entry in
the HA registry. HA  Registry: '129 TESTCF02 0 cf2-0,cf2-1 -
CF' db2nodes.cfg: '129 TESTCF02 0 cf2-0,cf2-1 - CF'. Compare
the contents db2nodes.cfg and the output of db2hareg -dump

Even though the contents of the 'db2hareg-dump' output and the
db2nodes.cfg file match:

$ cat db2nodes.cfg | grep CF
128 TESTCF01 0 cf1-0,cf1-1 - CF
129 TESTCF02 0 cf2-0,cf2-1 - CF

$ db2hareg -dump | grep CF
A05000500000000,NL,128,TESTCF01,0,cf1-0,cf1-1,-,CF
A05000500000000,NL,129,TESTCF02,0,cf2-0,cf2-1,-,CF

The following error is seen in the db2diag.log:

2015-05-08-14.39.52.074979+480 I12640A436           LEVEL: Error
PID     : 4915290              TID : 1              PROC :
db2cluster
INSTANCE: db2inst1              NODE : 000
HOSTNAME: TESTDB
EDUID   : 1
FUNCTION: DB2 UDB, high avail services,
sqlhaUIValidateDb2nodesMatchHaReg, probe:1424
MESSAGE : db2nodes.cfg and HA Registry type comparison failed
DATA #1 : String, 23 bytes
CF01 0 cf1-0,cf1-1 - CF
DATA #2 : String, 2 bytes
CF

2015-05-08-14.39.52.076345+480 I13077A436           LEVEL: Error
PID     : 4915290              TID : 1              PROC :
db2cluster
INSTANCE: db2inst1              NODE : 000
HOSTNAME: TESTDB
EDUID   : 1
FUNCTION: DB2 UDB, high avail services,
sqlhaUIValidateDb2nodesMatchHaReg, probe:1424
MESSAGE : db2nodes.cfg and HA Registry type comparison failed
DATA #1 : String, 23 bytes
CF02 0 cf2-0,cf2-1 - CF
DATA #2 : String, 2 bytes
CF

This issue is encountered if a hostname contains the 'CF' or
'MEMBER' substring.

Local fix

  • Modify the hostname value ensuring that it does not contain the
'CF' or 'MEMBER' substring.

Problem summary

  • ****************************************************************
* USERS AFFECTED:                                              *
* User who use db2 v10.5 purescale feature                     *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to db2 v10.5 fixpack 7 or above                      *
****************************************************************

Problem conclusion

  • The problem is first fixed in db2 v10.5 fixpack 7

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IV73358
    • 

  • Reported component name
    DB2 PURESCALE F
    • 

  • Reported component ID
    5724Y6900
    • 

  • Reported release
    A50
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2015-05-17
    • 

  • Closed date
    2016-01-20
    • 

  • Last modified date
    2016-01-20
    • 





    

  • APAR is sysrouted FROM one or more of the following:
    

    • 

  • APAR is sysrouted TO one or more of the following:
    

    • 



Fix information


    

  • Fixed component name
    DB2 PURESCALE F
    • 

  • Fixed component ID
    5724Y6900
    • 



Applicable component levels


    








      
              
                            

              

              [{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.5","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            07 June 2022
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback