Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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 FixList