|
Problem IC65700
|
Status: Closed |
DB2DART /DEMP WILL FAIL WHEN EXCESSIVE EXTENTS IN TABLESPACE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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: |
|
| available fix packs: |
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
|
| Solution |
Problem was first fixed in Version 9.7 Fix Pack 2 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 20.01.2010
31.05.2010
31.05.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP2,
9.70.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
