IBM Support

IC79631: DB2DART ERROR - UNEXPECTED LOB INLINE LENGTH

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • 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
    

Local fix

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

Problem summary

  • ****************************************************************
    * 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            *
    ****************************************************************
    

Problem conclusion

  • Problem first fixed in Version 9.7 Fixpack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC79631

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-11-04

  • Closed date

    2012-06-05

  • Last modified date

    2012-06-05

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC84250

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC79631

Modified date: 05 June 2012