IBM Support

IT25400: DB2PD -HA CAN OUTPUT "COULD NOT RETRIEVE NUMBER OF RESOURCE GROUPS IN THE CLUSTER"

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • db2pd -ha can output "Could not retrieve number of Resource
    Groups in the cluster"
    
    If you created the TSA cluster outside db2haicu and create
    custom resource that include the instance name the db2pd -ha
    command can return message reporting unable to retrieve number
    of resource groups.
    
    Db2 tries to query these resources because they contain the
    instance name and since db2haicu did not set them up it hits an
    error. Db2 should ignore these resources since they were set up
    by the customer.
    
    example:
    
    $db2pd -ha
    DB2 HA Status
    Instance Information:
    Instance Name = db2inst1
    Number Of Domains = 1
    Could not retrieve number of Resource Groups in the cluster
    
    db2diag.log:
    
    2018-06-07-15.41.57.754492+000 E1974A591 LEVEL: Error
    PID : 6095628 TID : 1 PROC : db2pd
    INSTANCE: db2inst1 NODE : 000
    HOSTNAME: db2host
    EDUID : 1
    FUNCTION: <0>, <0>, <0>, probe:1838
    RETCODE :
    ECF=0x90000552=-1879046830=ECF_SQLHA_OBJECT_DOES_NOT_EXIST
    Cluster object does not exist
    DATA #1 : String, 71 bytes
    libsqlha: sqlhaGetMemberResourceGroup() call error from wrapper
    library
    DATA #2 : String, 0 bytes
    Object not dumped: Address: 0x000000011150F3FC Size: 0 Reason:
    Zero-length data
    DATA #3 : signed integer, 4 bytes
    0
    
    2018-06-07-15.41.57.755405+000 E2566A392 LEVEL: Error
    PID : 6095628 TID : 1 PROC : db2pd
    INSTANCE: db2inst1 NODE : 000
    HOSTNAME: db2host
    EDUID : 1
    FUNCTION: DB2 UDB, high avail services,
    sqlhaGetMemberResourceGroup, probe:50
    RETCODE :
    ECF=0x90000552=-1879046830=ECF_SQLHA_OBJECT_DOES_NOT_EXIST
    Cluster object does not exist
    
    The customer can work around this by renaming these resources
    and removing the instance name.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher                *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT25400

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-06-18

  • Closed date

    2018-11-27

  • Last modified date

    2018-11-27

  • 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 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
27 November 2018