|
Problem IC96227
|
Status: Geschlossen |
RUNSTATS WITH SYSTEM SAMPLING ON A COLUMN-ORGANIZED TABLE MIGHT PRODUCE AN INCORRECT COLCARD STATISTIC |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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. |
| verfügbare FixPacks: |
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
|
| Lösung |
Problem was first fixed in DB2 Version 10.5 Fix Pack 1 |
| Workaround |
See Local Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 25.09.2013
27.02.2014
27.02.2014 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
