DB2 - Problem description
| Problem IT07245 | Status: Closed |
LOAD FROM CURSOR FROM CHAR TO VARGRAPHIC VALUE FAILS TO LOAD INTO THE COLUMN. | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
| Problem description: | |
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 Summary: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to version 10.5 FP7 * **************************************************************** | |
| Local Fix: | |
Upgrade to version 10.5 FP7 | |
| Solution | |
Upgrade to version 10.5 FP7 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 19.02.2015 21.01.2016 21.01.2016 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 10.5.0.7 |
|