|
Problem IC78107
|
Status: Geschlossen |
INADEQUATE INDEX LEAF PAGE READAHEAD DONE DURING REORG INDEX CLEANUP ONLY LEADING TO POOR PERFORMANCE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
The "reorg index for table .... cleanup only" option uses a
readahead algorithm to asynchronously load index leaf pages into
the bufferpool. However, there is a problem with readahead
algorithm causing it to not prefetch all of the pages that it
should when the index contains an extremely large number of
duplicate records.
Hence the db2agent processing the cleanup operation needs to
synchronously load too many pages into the bufferpools, leading
to bad performance of the reorg command. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Apply DB2 v9.7 Fix Pack 6 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
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 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
This problem has first been fixed in V9.7 Fix Pack 6 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 12.08.2011
18.06.2012
18.06.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP6
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.6
|
 |
