DB2 FOR LUW / DB2FORLUW / A50 - DB2

When inserting into an insert time clustering (ITC) table (i.e. 
a table created with the ORGANIZE BY INSERT TIME option of the 
CREATE TABLE statement), the INSERT statement might get stuck in 
an infinite loop while searching for free space.  The problem 
occurs after a portion of the table has been filled and emptied 
hundreds of times.  The database manager incorrectly treats the 
ITC table as it were in append mode, resulting in wasted space 
in the table as deleted slots are never reused and more more 
slots are added to pages.  Eventually all the pages in multiple 
extents contain so many deleted slots that there is no longer 
room for a single record in the page.  The database manager 
updates the state of these pages in an infinite loop until a 
transaction log full error is hit. 
 
A trace of the INSERT statement will show the following two 
functions being called repeatedly: 
 
sqldExtendAppendCache 
sqldSwitchFromAppendToPossiblyEmpty 
sqldVirtualColumnDeleteKey 
sqldVirtualColumnAddKey 
 
and 
 
sqldExtendAppendCache 
sqldCreateNewAppendCache 
sqldCreateAppendCachePagesForMDCTable 
sqldVirtualColumnDeleteKey 
sqldVirtualColumnAddKey

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 7.                      * 
****************************************************************

Force the application inserting into the ITC table and recreate 
the table without the ORGANIZE BY INSERT TIME option.

First fixed in DB2 Version 10.5 Fix Pack 7.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

16.07.2015
21.01.2016
21.01.2016