PM90310: CHECK DATA AUXERROR INVALIDATE DOES NOT INVALIDATE THE LOB COLUMNS FOR DSNDB01.SPT01 AND DSNDB01.DBD01

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • CHECK DATA AUXERROR INVALIDATE does not invalidate the LOB
    columns for DSNDB01.SPT01 and DSNDB01.DBD01
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 10 for z/OS users of CHECK DATA      *
    *                 AUXERROR INVALIDATE on directory objects     *
    ****************************************************************
    * PROBLEM DESCRIPTION: CHECK DATA AUXERROR INVALIDATE was      *
    *                      ignored for LOB columns for directory   *
    *                      objects.                                *
    ****************************************************************
    * RECOMMENDATION: Apply corrective PTF when available          *
    ****************************************************************
    CHECK DATA TABLESPACE DSNDB01.SPT01 AUXERROR INVALIDATE
    issued multiple MSGDSNU809I indicating missing AUX index entries
    but was not invalidating the LOB columns.  CHECK DATA SHRLEVEL
    REFERENCE AUXERROR INVALIDATE should invalidate LOB columns
    for directory objects.  CHECK DATA SHRLEVEL CHANGE AUXERROR
    INVALIDATE should generate REPAIR statements for invalid LOB
    columns for directory objects.
    

Problem conclusion

  • CHECK DATA has been modified to honor AUXERROR INVALIDATE
    for directory objects.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM90310

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-06-03

  • Closed date

    2013-09-03

  • Last modified date

    2013-10-04

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

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

    UK97263

Modules/Macros

  • DSNUKERK DSNUKRDN DSNUKRDY
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK97263

       UP13/09/21 P F309

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 #:

PM90310

Modified date:

2013-10-04

Translate my page

Machine Translation

Content navigation