IC88431: HADR STANDBY MAY HANG WHEN ROS IS ENABLED

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When Read On Standby is enabled, the DB2 Standby database may
    hang ( and eventually cause the primary database to hang ).
    The db2redom ( redo master ) edu will show a stack with top
    functions :
    
    HdrKickPooledAgents
    HdrForceAppsInReplayOnlyWindow
    
    and there will be an Asynchronous Background Process (ABP or
    db2taskp ) that show as suspended with a stack trace similar to
    :
    
    
    
    thread_wait
    sqloWaitEDUWaitPost
    IntrptWaitLock
    getTaskProAssignment
    main
    abpAgentEntryPoint
    sqleIndCoordProcessRequest
    
    The problem is timing dependent and will not always occur.
    

Local fix

  • On the standby instance set :
    db2set DB2_DISABLE_ABP=ON
    before starting the instance, this will disable the Asynchronous
    background tasks from starting.
    However, this should not be set on the primary as that may cause
    maintenance problems ( e.g. Asynchronous Index Cleanup not
    running . ).
    Hence when a failover happens,  a failback should be done as
    soon as possible, or the registry variable should be unset.
    
    on the standby server.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * HADR users                                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * upgrade the DB2 server to V9.7 Fix Pack 8                    *
    ****************************************************************
    

Problem conclusion

  • This problem has first been fixed in V9.7 Fix Pack 8
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC88431

  • 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-11-20

  • Closed date

    2013-04-19

  • Last modified date

    2013-04-19

  • 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

  • R970 PSN

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.7

Reference #:

IC88431

Modified date:

2013-04-19

Translate my page

Machine Translation

Content navigation