IC95903: DB2 ROLLFORWARD MIGHT HANG IN BACKWARD PHASE WHEN INFINITE LOGGING IS USED

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DB2 rollforward might hang in backward phase with db2loggr
    thread showing the following stack trace:
    
    EDU name     : db2loggr (SAMPLE) 0
    EDU ID       : 5807
    
    <StackTrace>
    -------Frame------ ------Function + Offset------
    0x09000000007EC570 _p_nsleep + 0x10
    0x090000000002B9C4 nsleep + 0xE4
    0x0900000000155808 nanosleep + 0x188
    0x090000002ADA15A0 ossSleep + 0x80
    0x090000002F5697D8 sqlorest + 0x5C
    0x090000002DB2E5BC sqlpgLoggrSleep__FP9SQLP_DBCBUl + 0xC0
    0x090000002DB301BC sqlpgadf__FP9SQLP_DBCBb + 0x36C
    0x090000002BDC387C sqlpgasn__FPcUi + 0x4B4
    0x090000002F4CC68C sqloEDUEntry + 0x1C
    </StackTrace>
    
    The problem could only happen when infinite logging is used and
    may require below conditions:
    1) there is some very large transaction to rollback
    2) frequent restore and rollforward.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Problem Description above.                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 10.5 Fix Pack 4.                      *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 10.5 Fix Pack 4.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC95903

  • 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-09-09

  • Last modified date

    2014-09-09

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

    IC94494

  • 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 #:

IC95903

Modified date:

2014-09-09

Translate my page

Machine Translation

Content navigation