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 IC65668 Status: Geschlossen

SQL901 ON DOUBLE-BYTE XML PARAMETER OF TYPE SQLDD_XMLSTR_EXTENC

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
Bindin of variables of type SQLDD_XMLSTR_EXTENC (external 
encoding) assumes that the length is a CLOB length, i.e. in 
characters, but XMLSTR_EXTENC can also be used to transport DBCS 
data if the codepage is set to 1200 (UCS2). In this case, we hit 
a -901 assertion because the length does not match the length of 
the buffer. Solution is to treat XMLSTR_EXTENC with codepage 
1200 the same as we treat DBCS data.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* UDB V97 FP1 and earlier using JDBC to send XML in codepage   * 
* 1200 to the server                                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Binding in of XML as an XMLSTR_EXTENC datatype was not       * 
* correctly counting the bytes if the codepage of the XML was  * 
* 1200 (external). This causes errors during bindin of these   * 
* XML values.                                                  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to version 9.7 fix pack 2                            * 
****************************************************************
Local-Fix:
Workaround is to use XMLSTR_INTENC or to avoid EXTENC with 
codepage 1200 data.
verfügbare FixPacks:
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

Lösung
UDB V97 FP2 now treats SQLDD_XMLSTR_EXTENC of codepage 1200 as 
DBCS stream, not an SBCS stream, so the byte counts are 
accurate.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
19.01.2010
30.06.2010
30.06.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP2
Problem behoben lt. FixList in der Version
9.7.0.2 FixList