|
Problem IC66098
|
Status: Geschlossen |
COMPRESSION RATIO VALUE IN SYSCAT.INDEXES NOT VERY ACCURATE WHEN USING RANGE PARTITIONED TABLES AND PARTITIONED INDEXES |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
Enhance runstats to provide more accurate compression ratio
information (stored in syscat.indexes)
when dealing with range partitioned indexes with many sparsely
populated partitions.
When a large number of range partitions in an index are empty
the overall compression ratio is
lower than expected. However, if the sparsely populated ranges
are eliminated from the
calculation the compression ratio is more accurate. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Db2 9.7 FP1 and previous release *
****************************************************************
* PROBLEM DESCRIPTION: *
* When a large number of range partitions in an index *
* areemptythe overall compression ratio islower than expected. *
* However, if the sparsely populatedrangesare eliminated from *
* thecalculation the compression ratio is more accurate. *
****************************************************************
* RECOMMENDATION: *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
Enhance runstats to provide more accurate compression ratio
information (stored in syscat.indexes)
when dealing with range partitioned indexes with many sparsely
populated partitions. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Kommentar |
syscat.indexes view information was improved to return a more
accurate copression ratio information |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC67249
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 04.02.2010
31.08.2010
31.08.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.2
|
 |
