DB2 - Problembeschreibung
Problem IC65700 | Status: Geschlossen |
DB2DART /DEMP WILL FAIL WHEN EXCESSIVE EXTENTS IN TABLESPACE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
If a tablespace has many extents, like the case of a 2TB database with extent size of 2 (pagesize 16K), db2dart /demp can give this output DAT extent anchor: 61256 Traversing extent map for object type: 0 Pool: 8, Object: 10689 EMP page class: 64, EMP pool page: 61256, # entries: 22 Page LSN = 0F71 2196 CBE4 Pool relative page #'s : 61258 8510874 7761676 22479636 31539528 38681348 42170384 49708944 58053836 62346196 67549266 72538854 81950540 94038900 97659566 110973532 112317730 112936274 115193574 120843188 124144468 131180934 FYI: Available (128) SMP buffer used for checking full in touchextent. No more checking was done. ix= 130 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * If a tablespace has many extents, like the case of a * * 2TBdatabase with extent size of 2 (pagesize 16K), * * db2dart/demp can give this outputDAT extent anchor: * * 61256Traversing extent map for object type: 0Pool: 8, * * Object: 10689 EMP page class: 64,EMP pool page: 61256, # * * entries: 22Page LSN = 0F71 2196 CBE4Pool relative page #'s * * :61258 8510874 7761676 22479636 3153952838681348 42170384 * * 49708944 58053836 6234619667549266 72538854 81950540 * * 94038900 97659566110973532 112317730 112936274 115193574 * * 120843188124144468 131180934FYI: Available (128) SMP buffer * * used for checking full intouchextent. No more checking was * * done. ix= 130 * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 9.70.FP2 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in Version 9.7 Fix Pack 2 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 20.01.2010 31.05.2010 31.05.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP2, 9.70.FP2 | |
Problem behoben lt. FixList in der Version | |
9.7.0.2 |