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

Obtain the fix for this APAR.

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 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.