PI69250: STORAGE OVERLAY CAUSED BY RUNSTATS HISTOGRAM WHEN QUANTILENO = -1 IN SYSIBM.SYSCOLDISTSTATS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Storage overlay caused by runstats histogram when quantileno =
  -1 in sysibm.syscoldiststats
  Possible ABENDS
  ABEND04E RC00E70005 at DSNXGRDS DSNX9CCM  offset 1B2E
  or
  ABEND0C4 RC0000003B at DSNXGRDS DSNX9CCM  offset 1058
  or
   ABEND0C4 RC00000038 at DSNSLD4  DSNSVSFB offset 0690
  or
  ABEND0C4 RC0000003B at DSNXGRDS DSNX9DIS offset 116C
  
  Additional symptoms and search keywords
  ABEND04E RC00E70005 ABEND0C4  RC0000003B RC00000038
  DB2OVERLAY/K
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All DB2 12 for z/OS users of RUNSTATS utility.               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Storage overlay is caused by RUNSTATS TABLESPACE INDEX PART  *
  * with HISTOGRAM option when records with QUANTILENO = -1      *
  * exist in SYSIBM.SYSCOLDISTSTATS.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available.                         *
  ****************************************************************
  Storage overlay occurred when a part level RUNSTATS TABLESPACE
  INDEX with HISTOGRAM option was aggregating the part level
  histogram statistics to index space level, but records with
  QUANTILENO = -1 was read from the catalog table
  SYSIBM.SYSCOLDISTSTATS.
  
  The same problem can happen when records with QUANTILENO = -1
  was read from SYSIBM.SYSKEYTGTDISTSTATS for extended index, and
  for part level RUNSTATS INDEX, as well as part level LOAD, REORG
  or REBUILD INDEX utility with inline statistics.
  The problem can also happen for data-partitioned secondary index
  (DPSI) or COLGROUP HISTOGRAM.
  
  Additional Keywords:
  DB2OVRLAY/K
  ABEND04E RC00E70005 at DSNXGRDS DSNX9CCM OFFSET1B2E
  ABEND0C4 RC0000003B at DSNXGRDS DSNX9CCM OFFSET1058
  ABEND0C4 RC0000003B at DSNXGRDS DSNX9DIS OFFSET116C
  ABEND0C4 RC00000038 at DSNSLD4  DSNSVSFB OFFSET0690
  

Problem conclusion

• RUNSTATS code has been modified to avoid this storage overlay.
  However inaccurate histogram statistics could be aggregated to
  index space level by part level RUNSTATS, because the existing
  rows with QUANTILENO = -1 in SYSCOLDISTSTATS or
  SYSKEYTGTDISTSTATS will be ignored and there might be missing
  statistics from affected partitions.
  
  Users are recommended to run a table space or index space level
  RUNSTATS to refresh the part level statistics.
  

Temporary fix

Comments

APAR Information

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

  PI64062

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

  UI41969

Modules/Macros

• DSNUSAH1 DSNUSAH2
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI41969

     UP16/11/14 P F611

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.