home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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 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 FixList