IBM Support

IC81993: WHEN STARTING DB2 USING THE DB2START COMMAND ON A BUSY SYSTEM, NOT ALL DB2 DATABASE PARTITION RESOURCE GROUPS ARE UNLOCKED.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • After issuing a db2start command as the instance owner, TSA MP
    does not unlock some database partitions, and the DB2 partition
    resource remains offline. Furthermore, the following db2diag.log
    message is seen for the affected partition during db2start
    processing:
    
    2012-01-01-12.00.00.000000-xxx E39330513A727      LEVEL: Error
    PID    : 975766              TID  : 1          PROC : db2stop2
    INSTANCE: db2inst1              NODE : 000
    EDUID  : 1
    FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure,
    sqlhaEnableResourceGroup, probe:500
    MESSAGE :
    ECF=0x90000550=-1879046832=ECF_SQLHA_ENABLE_GROUP_FAILED
              Error unlocking resource group
    DATA #1 : String, 43 bytes
    Cluster Error during vendor call invocation
    DATA #2 : unsigned integer, 4 bytes
    18
    DATA #3 : String, 17 bytes
    db2_db2inst1_0-rg
    DATA #4 : unsigned integer, 8 bytes
    1
    DATA #5 : signed integer, 4 bytes
    0
    DATA #6 : String, 84 bytes
    Line # : 5896---db2haGetGroupLockState timeout, group could not
    be verified enabled
    

Local fix

  • Re-issue the db2start command until all DB2 partition resource
    groups are succesfully unlocked.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Large multi-partition clustered DB2 environments.            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * In a large clustered DB2 HA environment (TSA), the db2start  *
    * command does not successfully unlock all DB2 database        *
    * partition resource groups.                                   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to V9.7.0.6                                          *
    ****************************************************************
    

Problem conclusion

  • Upgrade to V9.7.0.6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC81993

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-03-13

  • Closed date

    2012-06-04

  • Last modified date

    2012-06-04

  • 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

  • R950 PSY

       UP

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC81993

Modified date: 04 June 2012