PM67696: ABEND04E DSNOLDEL 5005 DURING BIND AFTER REORG OF SPT01 ALONG WITH OTHER PROBLEMS

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • After REORG of SPT01, binds fail, because auxillary table
    spaces SYSSPUXB and SYSSPUXA are empty. This error is specific
    to reorg of spt01 with AUX YES and KEEPDICTIONARY for V10.
    Other errors DSNU809I ( MSGDSNU809I )
    DSNU809I    177 14:42:55.60 DSNUKERK - TABLE=SYSIBM.SPTR
    COLUMN=SPTSEC_EXPL IS MISSING IN INDEX SYSIBM.DSNSPEXA
    ROWID=X'69E2A59728E93898E81401213BA40100010000000619'
                          VERSION=X'0001'
    DSNU042I   DSNUGLSR - SORT PHASE STATISTICS -
               NUMBER OF RECORDS=0
               ELAPSED TIME=00:00:00
    

Local fix

  • Do not use AUX YES or KEEPDICTIONARY
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 10 for z/OS users of REORG           *
    *                 TABLESPACE utility on DSNDB01.SPT01          *
    ****************************************************************
    * PROBLEM DESCRIPTION: Data corruption in the LOB table spaces *
    *                      of a compressed DSNDB01.SPT01 after     *
    *                      REORG AUX YES completion                *
    ****************************************************************
    * RECOMMENDATION: Apply corrective PTF when available          *
    ****************************************************************
    User ran a REORG TABLESPACE AUX YES KEEPDICTIONARY on a
    compressed DSNDB01.SPT01 directory table space in V10 NFM.
    The REORG completed successfully, but subsequent bind jobs
    failed with ABEND04E DSNOLDEL ERQUAL5005 due to corrupted LOB
    data in DSNDB01.SYSSPUXA and DSNDB01.SYSSPUXB, which did not
    contain any LOB data at all.
    
    The reported problem is caused by an incorrect program logic
    error, where REORG AUX YES KEEPDICTIONARY on a compressed
    DSNDB01.SPT01 table space failed to populate the LOB table
    space correctly when it operated on data records with the
    incorrect compression attribute.
    

Problem conclusion

  • Code has been modified to correct the aforementioned data
    corruption on a REORG AUX YES of DSNDB01.SPT01.
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    PM67696

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-06-26

  • Closed date

    2012-08-02

  • Last modified date

    2012-09-05

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

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

    UK80830

Modules/Macros

  •    DSNURFIT
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK80830

       UP12/08/23 P F208

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.



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM67696

Modified date:

2012-09-05

Translate my page

Machine Translation

Content navigation