PM35419: RUNSTATS TABLESPACE WITH TABLESAMPLE KEYWORD ABENDS 04E IN DSNIBMCL ERQUAL 500B

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • RUNSTATS TABLESPACE with TABLESAMPLE option abends in DSNIBMCL
    with ERQUAL500B and MSGDSNI011I PAGE TEMPORARILY UNAVAILABLE
    is issued + broken page does online page recovery.
    Additional symptoms: DSNINXPG 0C04 ERQUAL0C04
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 RUNSTATS using the          *
    *                 TABLESAMPLE keyword with table spaces that   *
    *                 are compressed.                              *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND04E RC00C90101 AT DSNIBMCL         *
    *                      ERQUAL500B during RUNSTATS with         *
    *                      TABLESAMPLE keyword                     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When accessing data, DB2 was not expecting a dictionary page
    after the first data page.  This can occur when auto
    compression is used, that is, rows are compressed during
    insert.
    

Problem conclusion

  • The code is changed to recognize a dictionary page after the
    first data page in a pageset or partition and to skip it rather
    than abending.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM35419

  • 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

    2011-03-22

  • Closed date

    2011-04-08

  • Last modified date

    2011-05-01

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

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

    UK66683

Modules/Macros

  • DSNINXPG
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK66683

       UP11/04/27 P F104

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

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM35419

Modified date:

2011-05-01

Translate my page

Machine Translation

Content navigation