PM75275: DATAREPEATFACTOR IN SYSIBM.SYSINDEXSTATS IS INCORRECTLY SET TO ZERO BY RUNSTATS INDEX AT PART LEVEL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• RUNSTATS INDEX at PART level is setting DATAREPEATFACTORF=0 in
  SYSIBM.SYSINDEXSTATS for every index partitions, and also
  setting DATAREPEATFACTORF=0 in SYSIBM.SYSINDEXES for the whole
  partitioned index.
  This is causing Access Path issues.
  DATAREPEATFACTORF should not be zero, as stated in "SQL
  Reference" manual.
  It looks this happenes when there are empty partitions.
  

Local fix

• Runstats the whole tablespace.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 for z/OS and DB2 10 for z/OS       *
  *                 users of RUNSTATS utility on a partitioned   *
  *                 table space with DB2 subsystem parameters    *
  *                 STATROLL=YES and STATCLUS=ENHANCED.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: DATAREPEATFACTORF is 0 in catalog       *
  *                      table SYSIBM.SYSINDEXSTATS and          *
  *                      SYSIBM.SYSINDEXES after RUNSTATS INDEX  *
  *                      PART n on a non-empty partitioned       *
  *                      table space with ZPARM                  *
  *                      STATCLUS=ENHANCED and STATROLL=YES.     *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  A RUNSTATS INDEX PART n was run on a partitioned table space
  with DB2 system parameters STATCLUS=ENHANCED and STATROLL=YES.
  The DATAREPEATFACTORF statistic was 0 in both the SYSINDEXSTATS
  and SYSINDEXES catalog tables and also reported as 0 in
  MSGDSNU617I and MSGDSNU627I, but the table was not empty.
  
  A similar problem can occur during the LOAD, REORG or REBUILD
  INDEX utility when gathering inline statistics on indexes.
  

Problem conclusion

• Code has been modified to correctly update SYSINDEXSTATS and
  SYSINDEXES with the value for DATAREPEATFACTOR and to report
  the value correctly in DSNU617I and DSNU627I.
  
  A documention change is needed in the SQL REFERENCE for catalog
  tables SYSINDEXES, SYSINDEXES_HIST, SYSINDEXSTATS and
  SYSINDEXSTATS_HIST
  
  The description for DATAREPEATFACTORF will read as follows:
  The anticipated number of data pages that will be touched
  following an index key order.  This statistic is only collected
  when the STATCLUS subsystem parameter is set to ENHANCED.  This
  number is -1 if statistics have not been collected.  This is an
  updatable 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:

  UK83682 UK83683

Modules/Macros

• DSNUSAIX DSNUSEOF DSNUSUIX DSNUSUPI
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK83682

     UP12/12/06 P F212

• R910 PSY UK83683

     UP12/12/06 P F212

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.