DB2 FOR LUW / DB2FORLUW / 950 - DB2

Problem can be reproduced by the following steps (in DPF mode): 
 
create db source 
create db target 
connect to source 
grant dbadm on database to newton 
 
create table loadremf.T1 ( smallint1 smallint, int1      int, 
bigint1  bigint, float1    float, real1    real, double1 
double, char1    char(1), char50    char(50), varchar1 
varchar(100), long1    long varchar, blob10    blob(10), 
clob100  clob(100), date1    date, time1    time, tstamp1 
timestamp ) 
 
load from loadremf.del of del replace into loadremf.source 
connect reset 
 
connect to target 
 
create table loadremf.T1 ( smallint1 smallint, int1      int, 
bigint1  bigint, float1    float, real1    real, double1 
double, char1    char(1), char50    char(50), varchar1 
varchar(100), long1    long varchar, blob10    blob(10), 
clob100  clob(100), date1    date, time1    time, tstamp1 
timestamp ) 
 
db2 declare $tabname1 cursor database source user db2inst1 using 
*** for select "*" from $tabname1 
 
 
db2 load from $tabname1 of cursor modified by ANYORDER INSERT 
into 
$tabname1 DATA BUFFER 6000 DISK_PARALLELISM 10 FETCH_PARALLELISM 
yes 
PARTITIONED DB CONFIG STATUS_INTERVAL 1000 
 
When we reach the above load command in bold, it will give us: 
 
SQL0452N  Unable to access the file referenced by host variable 
"1".  Reason 
code: "5".  SQLSTATE=428A1

**************************************************************** 
* USERS AFFECTED:                                              * 
* Prior to DB2 V9.5 FP10                                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* IN DPF ENVIRONMENT, LOAD FROM CURSOR FAILED WITH SQL0452N    * 
* WHILE LOADING DATA FROM V97 TO V95.                          * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.5 FP10                                     * 
****************************************************************

First Fixed in DB2 V9.5 FP10

n/a

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

07.06.2012
28.08.2012
28.08.2012

9.5.FP10