|
Problem IC62185
|
Status: Closed |
INCORRECT LENGTH FOR XML FIELD DURING EXPORT |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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 Description:
CORRECT LENGTH FOR XML FIELD DURING EXPORT
Problem Summary
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.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 UDB Version 9.7, FixPak 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.07.2009
18.09.2009
18.09.2009 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
