|
Problem IC83058
|
Status: Closed |
LOB/LONG TABLESPACE GROWS MUCH LARGER THAN REQUIRED FOR THE ACTUAL DATA BEING STORED |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
The LOB/LF tablespace can suddenly begin growing in size much
faster than it should for the amount of data that is being
inserted. There are no error indications of any kind reported
unless the tablespace becomes full. Running inspect can show
that the total table pages are very high vs. the used pages like
below. This high total pages vs used pages result is not
expected for tables that are only inserting into the table.
INSPECT Output:
Table phase start (ID Signed: 5, Unsigned: 5; Tablespace ID:
3) : SCHEMA.TABLE
...
LOB phase start. Object: 4 Tablespace: 6
Traversing LOB extent map, anchor 192.
Extent map traversal complete.
Traversing LBA extent map, anchor 320.
Extent map traversal complete.
LOB Object Summary: Total Pages 2560 - Used Pages 131
LBA Object Summary: Total Pages 4 - Used Pages 2
LOB phase end.
Table phase end. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to db2 Version 10.1 FixPack 1 *
**************************************************************** |
| Local Fix: |
There is no workaround that will prevent the exceptional
tablespace growth.
Short term tablespace relief can only be gained by measures
that reduce the overall table size within the tablespace. (ie.
reorg -longlobdata, export/truncate/load, atm etc.) |
| available fix packs: |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in Version 10.1 FixPack 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.05.2012
01.11.2012
01.11.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
