IBM Support

IT23771: Roll forward or crash recovery may crash when working on index page.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Roll forward or crash recovery may crash with following stack
    when touching index page altered by load command
    followd by load terminate in the log to be rollforward or crash
    recovery.
    
    sqliScrubPage
    sqliScrubPseudoInserts
    sqlifix
    sqliRecFixpg
    sqliRedo
    sqldmrdo
    sqlpRecDbRedo
    sqlpPRecProcLog
    sqlpParallelRecovery
    sqleSubCoordProcessRequest
    RunEDU
    

Local fix

  • Contact support to mark the index bad during rollforward or
    crash recovery .
    Then recreate index after roll forward or crash recovery is
    done.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Roll forward or crash recovery may crash when working on     *
    * index                                                        *
    * page.                                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * First fixed in v11.1 fp4m5                                   *
    ****************************************************************
    

Problem conclusion

  • First fixed in v11.1 fp4m5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT23771

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-01-18

  • Closed date

    2019-10-31

  • Last modified date

    2019-10-31

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

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

    IT30807

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
31 October 2019