DB2 FOR LUW / DB2FORLUW / 950 - DB2

While exporting xml data - 
db2 export to file_del.del of del xml to /export_xml/  (select 
...) 
in the del file we can see incorrect length for the xml field 
(greater by 39 than actual length) 
 
for example - 
"<XDS FIL='file_del.del.001.xml' OFF='182' LEN='7011' />","<XDS 
FIL='file_del.del.001.xml' OFF='123033' LEN='7050' />" 
 
this causes importing to fail 
 
 
 
Fixing up the lengths of the exported data ,  importing the 
rows into the table is successful.

Users affected: ALL 
 
Problem Summary: 
INCORRECT LENGTH FOR XML FIELD DURING EXPORT 
 
Problem Description: 
While exporting xml data - 
db2 export to file_del.del of del xml to /export_xml/  (select 
...) 
in the del file we can see incorrect length for the xml field 
(greater by 39 than actual length) 
 
for example - 
"<XDS FIL='file_del.del.001.xml' OFF='182' LEN='7011' />","<XDS 
FIL='file_del.del.001.xml' OFF='123033' LEN='7050' />" 
 
this causes importing to fail 
 
 
 
Fixing up the lengths of the exported data ,  importing the 
rows into the table is successful. 
 
LOCAL FIX: 
Fixing up the lengths of the exported data ,  importing the 
rows into the table is successful.

Fixing up the lengths of the exported data ,  importing the 
rows into the table is successful.

DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 UDB Version 9.5, FixPak 5

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

28.07.2009
11.08.2009
11.08.2009

9.5.