home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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 FixList