DB2 FOR LUW / DB2FORLUW / 970 - DB2

There have been two ways found to cause this condition. 
 
1. When a view is created from a UNION ALL of tables, and then a 
table is created LIKE the view.  For example: 
 
create view V1 as select ... from T1 union all select ... from 
T2 
create table TAB1 like V1 
 
The view will have an inline length of 0 for its LOB columns, 
and the inline length is incorrectly inherited by the table TAB1 
that is created like the view. 
 
2. When a table is created as a select from another table and a 
LOB column is added as part of the new DDL.  For example: 
 
create table employee_excpt as ( select employee.*, current 
timestamp as excpt_ts, cast ('' as clob(32k)) as excpt_msg from 
employee ) with no data; 
 
The new table will have an incorrect inline length of 0 for its 
LOB column. 
 
When you run a db2dart on one of these table, you will see the 
following: 
 
Table inspection start: DB2INST1.EMPLOYEE_EXCPT 
 
         Data inspection phase start. Data obj: 4  In pool: 4 
         Error: Unexpected LOB inline length. 
         Data inspection phase end. 
 
         Error: Unexpected LOB inline length. 
         Error: Unexpected LOB inline length. 
         Error: Unexpected LOB inline length. 
         Error: Unexpected LOB inline length. 
         Error: The tablespace object-table and the data 
disagree on the existance of LOB data! 
         Warning: Table descriptor record indicates LOB exist: 0 
         Warning: DMS Object table indicates LOB exist:        1

**************************************************************** 
* USERS AFFECTED:                                              * 
* Any users that create a table like a view containing an      * 
* inline LOB or create a table from a select and append an     * 
* inline LOB to the definition                                 * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See APAR description                                         * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW Version 9.7 Fixpack 6 or later            * 
****************************************************************

alter the table column to the desired or default inline length: 
 
  alter table employee_excpt alter column excpt_msg set inline 
length <integer>

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
 

Problem first fixed in Version 9.7 Fixpack 6

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC84250 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

04.11.2011
05.06.2012
05.06.2012

9.7.FP6