IBM Support

PM85939: SYSTEM PAGE CORRUPTION AFTER REORG OR LOAD RESUME FOR A MEMBER CLUSTER PAGESET WITH PM76363 & UK90660/UK90661 PTFS APPLIED

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • System page corruption after REORG or LOAD RESUME for a member
    cluster pageset with PM76363 & UK90660/UK90661 ptfs applied,
    which are now marked PE
    
    Symptoms include:
    
    ABEND04E RC00C90101 ERQUAL2003 in DSNIPPS
    ABEND04E RC00C90101 ERQUAL500B in DSNIBMCL
    ABEND04E RC00E20001 DSNIROBD.DSNSVBK +297E (OFFSET297E)
    ABEND04E RC00E20001 DSNIROBD.DSNSVBK +2A10 (OFFSET2A10)
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: DB2 9 for z/OS or DB2 10 for z/OS users of   *
    *                 REORG and LOAD RESUME utilities against      *
    *                 classic partitioned table space with Member  *
    *                 Cluster, who have applied APAR PM76363 and   *
    *                 PTF UK90660/UK90661.                         *
    ****************************************************************
    * PROBLEM DESCRIPTION: Following problems could occur during   *
    *                      or after REORG or LOAD RESUME utility   *
    *                      when PM76363 has been applied:          *
    *                      -ABEND04E RC00C90101 DSNIPPS ERQUAL2003 *
    *                      -ABEND04E RC00C90101 DSNIBMCL           *
    *                                ERQUAL500B                    *
    *                      -ABEND04E RC00E20001 DSNIROBD.DSNSVBK   *
    *                      -Data loss                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Before PM76363/UK90660(UK90661), LOAD RESUME utility against
    classic partitioned TS with Member Cluster could fail with
    abend ABEND04E RC00C90101 at DSNIDLOD ERQUAL500A. This issue
    only happens when there are zero data pages between the last two
    space map pages, and data pages covered by the last space map
    page are empty. PM76363 is to let LOAD RESUME tolerate the zero
    data pages.
    
    After PM76363/UK90660(UK90661) is applied, REORG utility or LOAD
    RESUME utility against classic partitioned table space with
    Member Cluster might corrupt system page. As a consequence,
    later access to down level records could fail with
    aforementioned abends. For LOAD RESUME utility, data covered by
    the space map page second to the last one could be overwritten
    if all data pages covered by the last space map page happen to
    be empty pages.
    

Problem conclusion

  • DB2 code is modified to prevent the system page or data page
    corruption by REORG or LOAD RESUME utility against classic
    partitioned table space with Member Cluster.
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    PM85939

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    YesPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-03-29

  • Closed date

    2013-05-21

  • Last modified date

    2013-07-03

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

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

    UK94465 UK94466

Modules/Macros

  • DSNIDLOD
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK94466

       UP13/06/05 P F306 ®

  • R910 PSY UK94465

       UP13/06/05 P F306 ®

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"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
03 July 2013