DB2 FOR LUW / DB2FORLUW / 970 - 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:                                              * 
* All users in DPF environmet using Load from cursor with      * 
* LOBdata                                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* LOAD FROM CURSOR FROM A TABLE WITH LOB COLUMN IN             * 
* DPFENVIRONMENT MIGHT LOAD WRONG RESULTS IN THE TARGET TABLE  * 
* LOBCOLUMN                                                    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to Vesion 9.7 Fixpak 2 or later               * 
****************************************************************

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.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem is first fixed in Version 9.7 Fixpak 2

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.

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

06.01.2010
22.06.2010
22.06.2010

9.7.