DB2 - Problembeschreibung
| Problem IT07245 | Status: Geschlossen |
LOAD FROM CURSOR FROM CHAR TO VARGRAPHIC VALUE FAILS TO LOAD INTO THE COLUMN. | |
| Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
| Problembeschreibung: | |
LOAD from CURSOR from CHAR to VARGRAPHIC, value fails to load
into the column and db2diag.log has error entry:
2014-09-02-18.15.14.399532+000 I11372372A569 LEVEL: Error
PID : 20840978 TID : 20222 PROC :
db2sysc 0
INSTANCE: inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-36492 APPID: *LOCAL.inst1.140902181327
AUTHID : DB2INST1 HOSTNAME: server
EDUID : 20222 EDUNAME: db2lfrm0 0
FUNCTION: DB2 UDB, database utilities, sqluReportErrToDiag,
probe:0
DATA #1 : String, 107 bytes
LOADID: 53876.2014-09-02-18.13.34.092670.0 (13;133)
, 512, 0, Detected in file:sqlulxld_common.C, Line:937
The issue can be reproduced with the following steps:
db2 "create table tt (c1 char(2))"
db2 "create table tt2 (c1 vargraphic(2))"
db2 "insert into tt values('a')"
db2 "declare c cursor for select * from tt"
db2 load from c of cursor replace into tt2 <== load appears
successful, but has error entry in db2diag.log
db2 "select hex(c1) from tt2" <== nothing is in the column | |
| Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to version 10.5 FP7 * **************************************************************** | |
| Local-Fix: | |
Upgrade to version 10.5 FP7 | |
| Lösung | |
Upgrade to version 10.5 FP7 | |
| Workaround | |
keiner bekannt / siehe Local-Fix | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 19.02.2015 21.01.2016 21.01.2016 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
| Problem behoben lt. FixList in der Version | |
| 10.5.0.7 |
|