PM91592: ABEND0C4 RC10 AT DSNXOCN OFFSET4AB2 DURING BIND PACKAGE WITH EXPLAIN(YES)

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • During BIND PACKAGE with EXPLAIN(YES) specified this
    abend occurred:
    
    "DA06,ABND=0C4-00000010,U=A259953 ,M=C9 ,C=101.SCC
     -BINDPKG ,M=DSNTFRCV,LOC=DSNXGRDS.DSNXOCN +4AB2"
    
    The abend was due to a corrupted value in COLGROUPCOLNO in
    SYSIBM.SYSCOLDIST for one of the tables referenced by the
    package.
    

Local fix

  • Delete the invalid statistics and then run RUNSTATS to
    recollect valid statistics.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 who collect multi-column    *
    *                 frequency or histogram statistics            *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND0C4 RC10 at DSNXOCN + 4AB2 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 + 4AB2 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 OFFSET4AB2
    

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.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM91592

  • 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-21

  • Closed date

    2013-07-26

  • Last modified date

    2013-09-03

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

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

    UK96185

Modules/Macros

  • DSNXOCN
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK96185

       UP13/08/14 P F308

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

PM91592

Modified date:

2013-09-03

Translate my page

Machine Translation

Content navigation