DB2 - Problembeschreibung
Problem IC83997 | Status: Geschlossen |
IN DPF ENVIRONMENT, LOAD FROM CURSOR FAILED WITH SQL0452N WHILE LOADING DATA FROM V97 TO V95. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
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 | |
Problem-Zusammenfassung: | |
**************************************************************** * 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 * **************************************************************** | |
Local-Fix: | |
Lösung | |
First Fixed in DB2 V9.5 FP10 | |
Workaround | |
n/a | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 07.06.2012 28.08.2012 28.08.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP10 | |
Problem behoben lt. FixList in der Version | |
9.5.0.10 |