DB2 FOR LUW / DB2FORLUW / A50 - DB2

Running a LOAD TERMINATE on a table with XML column results in 
SQL1007N  (Error in finding pages for an object in a table 
space.)  The root cause is due to a series of failed LOADs 
against this table, specifically one in which the failure is 
early on and a value on XDA page 0 is not preserved.  The table 
is in LOAD PENDING state as well. 
 
This combination is normally not a problem because there is 
sufficient information in the LOAD control files to recover from 
this situation.  If the LOAD control files are missing, then the 
table cannot be LOAD TERMINATED and has to be LOAD REPLACED.

**************************************************************** 
* USERS AFFECTED:                                              * 
* No specific config.                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to v10.5fp3                                           * 
****************************************************************

Upgrade to DB2 10.1 fixpack 3 to prevent this from happening. 
Note that if the table is already in this bad state and is 
missing the LOAD control files, then the table cannot be LOAD 
TERMINATED and has to be LOAD REPLACED.

DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

Update to v10.5fp3

not known / see Local fix

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

24.10.2013
27.02.2014
27.02.2014