|
Problem IC96227
|
Status: Closed |
RUNSTATS WITH SYSTEM SAMPLING ON A COLUMN-ORGANIZED TABLE MIGHT PRODUCE AN INCORRECT COLCARD STATISTIC |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
If you use the SYSTEM sampling option of the RUNSTATS command to
collect statistics on a very large column-organized table, the
COLCARD statistics computed might be incorrect for columns with
a very large number of distinct values, approximately hundreds
of millions or more. The following is an example RUNSTATS
command using the SYSTEM sampling option:
RUNSTATS ON TABLE T1 WITH DISTRIBUTION TABLESAMPLE SYSTEM(20) |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 10.5 Fix Pack 1 *
**************************************************************** |
| Local Fix: |
You can avoid this problem by not using a sampling option in the
RUNSTATS command. |
| available fix packs: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in DB2 Version 10.5 Fix Pack 1 |
| Workaround |
See Local Fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.09.2013
27.02.2014
27.02.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
