IBM Support

PI15976: MODIFY RECOVERY LOOP IN DB2 V11

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In DB2 for z/OS version 11, Modify recovery loops due to
    changes in RBA
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 11 for z/OS users of MODIFY RECOVERY *
    *                 utility.                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION: An endless loop occurred in DSNUBCOP    *
    *                      while MODIFY RECOVERY utility was       *
    *                      running.                                *
    ****************************************************************
    * RECOMMENDATION: Apply corrective PTF when available.         *
    ****************************************************************
    When MODIFY RECOVERY is running, an endless loop might occur.
    This problem occurred due to incorrect COMMIT handling logic.
    As MODIFY RECOVERY was running, position on SYSLGRNX was not
    maintained correctly after a COMMIT, causing the same rows to
    be read repeatedly.
    

Problem conclusion

  • MODIFY RECOVERY utility code was changed to correctly maintain
    position on SYSLGRNX during COMMIT processing, thereby
    preventing the loop.
    

Temporary fix

  • *********
    * HIPER *
    *********
    

Comments

APAR Information

  • APAR number

    PI15976

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2014-04-14

  • Closed date

    2014-06-23

  • Last modified date

    2014-08-04

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

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

    UI19074

Modules/Macros

  •    DSNUBCOP
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI19074

       UP14/07/09 P F407 Ž

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"DB2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
31 July 2023