home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC79698 Status: Closed

DB2DART AND INSPECT REPORTS "LOB FREE SPACE WASTED." AS ERROR,
SHOULD BE REPORTED AS WARNING

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
The following message can be reported by db2dart and inspect: 
 
      LOB phase start. Object: 4  Tablespace: 408 
      Error: In page 1048, physical page 1048 of object 4 in 
tablespace 408, pagesize 16384. 
      Error: Hexadecimal dump of page contents. 
0000  *00303FD0 00000418 05000402 00000198* 
*.0..............* 
... 
3FF0  *00000000 00000000 00000000 00000000* 
*................* 
      LOB Free space wasted. Detected on buddy space 66816 on 
page 1048. 
 
This APAR will change the Error into a Warning, as this internal 
inconsistency is not critical.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 6.                       * 
****************************************************************
Local Fix:
REORG TABLE with LONGLOBDATA option
available fix packs:
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 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
First fixed in DB2 Version 9.7 Fix Pack 6.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC84364 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
09.11.2011
09.04.2013
09.04.2013
Problem solved at the following versions (IBM BugInfos)
9.7.FP6
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.6 FixList