IBM Support

IC73422: CRASH RECOVERY MAY USE OLD VERSION OF LOG PAGE FOR RECOVERY

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Crash recovery may use an older version of a log page to
    complete crash recovery, such that committed log records are not
    replayed. There may not be any error indicated on the crash
    recovery, but there could be missing data, or uncommitted data
    left in the database.
    
    This error can only occur while writing a partial log page to a
    new log file and a subsequent re-write of the same log page, to
    the last page of the current log file, is abnormally terminated
    (i.e. power outage).
    

Local fix

  • Restore and roll forward to point in time before end of logs.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Crash recovery may use an older version of a log page to     *
    * complete crash recovery,                                     *
    * as such, committed log records my not be replayed.  The      *
    * crash recovery may complete                                  *
    * successfully, but the database may contain uncommitted data  *
    * or missing data.                                             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 V9.7 Fix Pack 4.                              *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 V9.7 Fix Pack 4.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC73422

  • 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

    2010-12-21

  • Closed date

    2011-04-28

  • Last modified date

    2011-04-28

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

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

    IC73679

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

  • R980 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC73422

Modified date: 28 April 2011