IC95912: THE "DB2INSTANCE -LIST" COMMAND TAKES A LONG TIME TO RETURN WHEN A CLUSTER HOST IS OFFLINE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • In a pureScale environment, when a host is offline,
    the"db2instance -list" command is taking over 50 seconds to
    return. It is much slower compared to the case where all hosts
    are online. The command returns within 10 seconds in this case.
    
    For example, the "db2instance -list" may be seen as below when
    host8 was down, which took 60.33 seconds to return:
    
    /home/db2inst> time -p db2instance -list
    ID        TYPE             STATE                HOME_HOST
    CURRENT_HOST            ALERT   PARTITION_NUMBER
    LOGICAL_PORT    NETNAME
    --        ----             -----                ---------
    ------------            -----   ----------------
    ------------    -------
    0       MEMBER  WAITING_FOR_FAILBACK            host8
    host7               NO                  0                   1
    host7.XXX.com
    1       MEMBER           STARTED                host7
    host7               NO                  0                   0
    host7.XXX.com
    2       MEMBER           STARTED                host10
    host10               NO                  0                   0
    host10.XXX.com
    3       MEMBER           STARTED                host11
    host11               NO                  0                   0
    host11.XXX.com
    128     CF               PRIMARY                host6
    host6               NO                  -                   0
    host6.XXX.com
    129     CF                  PEER                host9
    host9               NO                  -                   0
    host9.XXX.com
    
    HOSTNAME                   STATE                INSTANCE_STOPPED
    ALERT
    --------                   -----                ----------------
    -----
    host11               ACTIVE                              NO
    NO
    host10               ACTIVE                              NO
    NO
    host7                ACTIVE                              NO
    NO
    host9                ACTIVE                              NO
    NO
    host6                ACTIVE                              NO
    NO
    host8              INACTIVE                              NO
    YES
    
    There is currently an alert for a member, CF, or host in the
    data-sharing instance. For more information on the alert, its
    impact, and how to clear it, run the following command:
    'db2cluster -cm -list -alert'.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 v10.5 FP3                                     *
    ****************************************************************
    

Problem conclusion

  • Problem Fixed In DB2 v10.5 FP3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC95912

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-09-12

  • Closed date

    2014-03-24

  • Last modified date

    2014-03-24

  • 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

  • RA50 PSN

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

10.5

Reference #:

IC95912

Modified date:

2014-03-24

Translate my page

Machine Translation

Content navigation