|
Problem IC63932
|
Status: Geschlossen |
PERFORMANCE DEGRADATION MAY OCCUR FOR CERTAIN WORKLOADS WITH QUE RIES THAT CONTAIN TABLE OR INDEX SCANS WITH SIMILAR PREDICATES |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
If multiple scans are running on the same tables or block
indexes with very similar speeds, some scans may
experience some performance degradation. The
degradation is due to pages being removed from the
buffer pool by earlier scans, which might be needed by the
later scans. The later scans will have to read in
these pages. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Users of MDC tables *
****************************************************************
* PROBLEM DESCRIPTION: *
* Table and block index scans may not perform optimally. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to the latest fix pack. *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
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 9a 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 10 for Linux, UNIX, and Windows
|
| Lösung |
Problem is first fixed in DB2 UDB Version 9.7 fix pack 1. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 21.10.2009
05.01.2010
05.01.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP1
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.1
|
 |
