DB2 - Problembeschreibung
Problem IC91221 | Status: Geschlossen |
CONTENTION DURING CONCURRENT LOADS CAUSED BY UNNECESSARY SMP PAGE SEARCHES | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
It is possible to observe a drop in performance when there are many concurrently running tasks requiring new extents to be allocated in a single tablespace. DB2 searches the Space Map Pages to find free extents. When there are no free extents tracked in these SMP pages, it is possible that DB2 performs repeated searches on SMP pages known to contain no free extent references. This can lead to a contention for the different tasks requiring a new extent, when there is a long chain of such SMP pages. ( e.g. in a large tablespace with a small extent size. ) | |
Problem-Zusammenfassung: | |
See APAR description | |
Local-Fix: | |
Create a tablespace with a larger extent size thereby reducing the number of SMP pages required. Split tables into several table spaces. | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows | |
Lösung | |
Problem first fixed in DB2 10.1 Fix Pack 3 | |
Workaround | |
See APAR description | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC95224 IT05541 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 02.04.2013 18.11.2014 18.11.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.3 | |
10.1.0.3 |