IC70696: BACKWARD PHASE OF ROLLFORWARD RECOVERY CAN BE VERY SLOW

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • During the backward stage of rollforward recovery - after either
    a system crash or during rollforward after a restore then DB2
    can repeatedly request the same two log files alternately.  This
    leads to the rollforward being extremely slow.
    In the db2diag.log the repeated requests for the same logs are
    recorded , eg :
    
    $ grep retrieve db2diag.log
    
    db2diag.log:MESSAGE : Started retrieve for log file
    S0000008.LOG.
    db2diag.log:MESSAGE : Completed retrieve for log file
    S0000008.LOG on chain 0 to
    db2diag.log:MESSAGE : Started retrieve for log file
    S0000009.LOG.
    db2diag.log:MESSAGE : Completed retrieve for log file
    S0000009.LOG on chain 0 to
    db2diag.log:MESSAGE : Started retrieve for log file
    S0000008.LOG.
    db2diag.log:MESSAGE : Completed retrieve for log file
    S0000008.LOG on chain 0 to
    etc
    
    
    The db2pd -recovery option will also show very slow bytes/second
    in backward
    phase of rollforward recovery.
    
    
    The problem is not platform specific.  The occurrence of the
    problem is chance dependent on whether a data buffer crosses two
    logfiles.
    The problem exists in the 9.5 and 9.7 codestreams.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 V9.5 FP7 or later                             *
    ****************************************************************
    

Problem conclusion

  • Problem first fixed in DB2 V9.5 FP7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC70696

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-08-23

  • Closed date

    2011-01-20

  • Last modified date

    2011-01-20

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

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

    IC70815

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R950 PSN

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.5

Reference #:

IC70696

Modified date:

2011-01-20

Translate my page

Machine Translation

Content navigation