A fix is available
APAR status
Closed as program error.
Error description
Runstats histogram produces unevenly distributed quantiles, with a lot of data fall into the last quantile
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 9 for z/OS and all DB2 10 for * * z/OS users of RUNSTATS utility collecting * * HISTOGRAM statistics. * **************************************************************** * PROBLEM DESCRIPTION: MSGDSNU636I and MSGDSNU632I shows * * uneven distribution in quantiles * * during RUNSTATS collection of * * HISTOGRAM statistics. * **************************************************************** * RECOMMENDATION: Apply corrective PTF when available * **************************************************************** When the user executed RUNSTATS INDEX or RUNSTATS TABLESPACE utility to collect HISTOGRAM statistics, MSGDSNU636I and MSGDSNU632I showed uneven distribution in quantiles. These statistics were stored in SYSIBM.SYSCOLDISTSTATS and SYSIBM.SYCOLDIST catalog tables. The uneven distribution in quantiles were caused by 1. An incorrect estimation of the table cardinality. 2. The algorithm to determine when to cut the quantile did not optimally cut the quantiles in the case of skewed data.
Problem conclusion
The code was modified to produce more even distribution in in the quantiles as follows: 1. To better estimate the number of records in the index during RUNSTATS INDEX execution. 2. The algorithm to collect HISTOGRAM statistics was changed to be more adaptive on skewed data distribution. 3. The HISTOGRAM statistics will collect HIGH values and LOW values in separate dedicated quantiles.
Temporary fix
Comments
APAR Information
APAR number
PM27249
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt
Submitted date
2010-11-22
Closed date
2011-05-17
Last modified date
2011-07-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK67816 UK67817
Modules/Macros
DSNUSAH1 DSNUSAH2 DSNUSDST DSNUSIDX DSNUSIIX DSNUSITS
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
05 July 2011