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

EXPORT CLOB TO IXF FILE, THEN IMPORT/LOAD THE CLOB INTO XML COLUMN
MIGHT FAIL TO LOAD THE CLOB WITH SQL3168W

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
Export CLOB to IXF file, then IMPORT/LOAD the CLOB into XML 
column might fail to load the CLOB with SQL3168W. 
 
This is due to the IXF file has non-zero double-byte codepage 
for the CLOB column, and IMPORT/LOAD code rejects that. 
IMPORT/LOAD should allow it.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Export CLOB to IXF file, then IMPORT/LOAD the CLOB into XML  * 
* column might fail to load the CLOB with SQL3168W.            * 
*                                                              * 
*                                                              * 
*                                                              * 
* This is due to the IXF file has non-zero double-byte         * 
* codepage for the CLOB column, and IMPORT/LOAD code rejects   * 
* that. IMPORT/LOAD should allow it.                           * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to version 9.5 Fix Pack 7.                           * 
****************************************************************
Local-Fix:
The workaround is to use  MODIFIED BY FORCEIN when doing 
IMPORT/LOAD.
verfügbare FixPacks:
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

Lösung
Problem was first fixed in version 9.5 Fix Pack 7. At a 
minimum, this fix should be applied on the client.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC71598 IC71599 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
30.09.2010
15.11.2010
15.11.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP7
Problem behoben lt. FixList in der Version
9.1.0.7 FixList
9.5.0.7 FixList