|
Problem IC62184
|
Status: Closed |
INCORRECT LENGTH FOR XML FIELD DURING EXPORT |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| 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. |
| Problem Summary: |
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. |
| Local Fix: |
Fixing up the lengths of the exported data , importing the
rows into the table is successful. |
| available fix packs: |
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
|
| Solution |
First fixed in DB2 UDB Version 9.5, FixPak 5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.07.2009
11.08.2009
11.08.2009 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.5
|
 |
