DB2 FOR LUW / DB2FORLUW / A10 - DB2

When loading data into an Multi-Dimensional Clustering (MDC) 
table using the LOAD command, a temporary table with an index is 
used to keep track of which dimension values are being loaded 
into the table.  The temporary table and it's index will be 
placed into a system temporary tablespace.  The index is created 
on all columns that are part of the ORGANIZE BY clause of the 
CREATE TABLE statement.  The maximum length of an index key 
(including all overhead) is index-page-size/4.  If no system 
temporary table space with a large enough page-size exists, then 
the LOAD command will fail with SQL1584N: 
 
SQL1584N  System temporary tablespace with page size of at least 
"<page size>" could not be found.  SQLSTATE=57055 
 
In DB2 version 10.1.0.4, the LOAD command incorrectly calculates 
the maximum length of the index key for the temporary table's 
index when variable-length columns are used.  For every 
variable-length columns listed in the ORGANIZE BY clause of the 
CREATE TABLE statement, the overhead of the key-part is 
incorrectly calculated to be 4 instead of 2 (or 5 instead of 3 
if column is not defined with the NOT NULL option).  The result 
is that the LOAD command might fail with SQL1584N.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.1.0.5.                             * 
****************************************************************

Create a system temporary table space with a larger page size.

The problem is first fixed in DB2 version 10.1.0.5.

not known / see Local fix

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

18.07.2014
13.07.2015
13.07.2015