DB2 FOR LUW / DB2FORLUW / 910 - DB2

In a partitioned database environment, if you have a table A 
with a LOB column with hundreds of thousands of rows, running 
the LOAD FROM CURSOR from table A to a table B 
might load incorrect data into the LOB column in table B. 
 
The following example shows an scenario where you can experience 
this problem: 
1. Create table A and table B with the same definition including 
 
  a LOB column. 
2. Insert more than one houndred thousand rows in table A. 
 
3. db2 "DECLARE mycurs CURSOR FOR SELECT * FROM A" 
 
4. db2 "LOAD FROM mycurs OF cursor INSERT INTO B" 
 
 
The LOAD command fetches rows from table A using a cursor and 
inserts them 
into table B. The LOB columns in table B might have incorrect 
data after the 
LOAD command is completed.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users in DPF environment using Load from cursor with lob     * 
* data.                                                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* LOAD FROM CURSOR FROM A TABLE WITH LOB COLUMN IN DPF         * 
* ENVIRONMENT                                                  * 
* MIGHT LOAD WRONG RESULTS IN THE TARGET TABLE LOB COLUMN      * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.1 Fixpak 9                              * 
* OR                                                           * 
* Use one of the Local Fixes listed                            * 
****************************************************************

Use one of the following alternatives: 
1. Use the LOAD command to load from a file instead of a cursor. 
 
2. Use the IMPORT command.

DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
 DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
 DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
 DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows
 

Problem is first fixed in Version 9.1 Fixpak 9

not known / see Local fix

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

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

06.01.2010
19.04.2010
19.04.2010

9.0.,
9.1.