DB2 - Problem description
Problem IT05512 | Status: Closed |
LOAD FROM CURSOR FROM CHAR TO VARGRAPHIC VALUE FAILS TO LOAD INTO THE COLUMN. | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - 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.1 FP5 * **************************************************************** | |
Local Fix: | |
Solution | |
First Fixed in Version 10.1 FP5 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 11.11.2014 16.07.2015 16.07.2015 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.1.0.5 |