PM93969: ABEND0C4 RC10 IN DSNXOCN +5092 DURING BIND/PREPARE IF QUERY REFERENCES COLUMN WITH BAD MULTI-COLUMN FREQ/HISTOGRAM STATS

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • ABEND0C4 RC10 in DSNXOCN +5092 during bind/prepare if query
    references a column with multi-column frequency or histogram
    statistics containing a column number in
    SYSCOLDIST.COLGROUPCOLNO that is out of range.  This is a
    forward fit of PM91592 to DB2 11 for z/OS.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 11 for z/OS who collect     *
    *                 multi-column frequency or histogram          *
    *                 statistics                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND0C4 RC10 at DSNXOCN +5092 can      *
    *                      occur on bind/prepare of a query if     *
    *                      there exists multi-column frequency or  *
    *                      histogram statistics on one or more of  *
    *                      the tables involved, and the statistics *
    *                      refer to a column number that is out of *
    *                      range.                                  *
    *                      This situation should not occur under   *
    *                      normal conditions, but may happen when  *
    *                      statistics get corrupted by errant      *
    *                      updates to SYSCOLDIST, etc.             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    ABEND0C4 RC10 at DSNXOCN +5092 can occur on bind/prepare of
    a query when there exists multi-column frequency or multi-column
    histogram statistics stored in SYSIBM.SYSCOLDIST for one or more
    tables in the query, and the COLGROUPCOLNO field refers to a
    column number that is outside the valid range of column numbers
    for the given table.
    
    Additional Keywords:
    SQLSTATS OFFSET5092
    

Problem conclusion

  • This fix will ignore the multi-column frequency or multi-column
    histogram statistic if the COLGROUPCOLNO refers to a column
    number outside of the valid range of column numbers for the
    given column.  This is a forward fit of APAR PM91592 into
    DB2 11 for z/OS.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM93969

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-07-26

  • Closed date

    2013-08-26

  • Last modified date

    2013-10-03

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

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

    UK97010

Modules/Macros

  • DSNXOCN
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UK97010

       UP13/09/11 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

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

B10

Reference #:

PM93969

Modified date:

2013-10-03

Translate my page

Machine Translation

Content navigation