IBM Support

PI28213: AVOID SETTING RECP FOR NOT LOGGED OR LOG(NO) LOB DURING RESTART

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A NOTLOGGED LOB tablespace was put into RECP during single
    member restart using restart light
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 users of LOB and NOT LOGGED objects. *
    ****************************************************************
    * PROBLEM DESCRIPTION: AVOID SETTING RECP FOR NOT LOGGED OR    *
    *                      LOG(NO) LOB DURING RESTART              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Today, during DB2 restart, if there is any logging activity
    against NOT LOGGED objects, it will be marked in RECP or
    RBDP/PSRBD. This results in users to run recover utility to
    remove this exception state. However, for the LOB space DB2
    always logs space map pages which is sufficient to recover LOB
    space during restart. This APAR will avoid unconditionally
    marking not logged LOBs in RECP. This will allow normal
    completion of LOB space recovery during restart.
    

Problem conclusion

  • DB2 restart logic for not logged objects is modified to avoid
    unconditionally marking LOB in RECP (Recover Pending) state.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI28213

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2014-10-22

  • Closed date

    2014-11-25

  • Last modified date

    2015-01-02

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

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

    UI23402 UI23403

Modules/Macros

  •    DSNIECUR
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI23402

       UP14/12/10 P F412

  • RB10 PSY UI23403

       UP14/12/10 P F412

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"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
06 May 2020