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

POSSIBLE CRASH (SEGV/ABORT) IN SQLDFORMATLOBLONGCOL() WITH LOAD FROM CURSOR
ON TABLE WITH LOB AND CODESET CONVERSION

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
It is possible for the engine to crash with segv when loading 
LOB that require code page conversion between the source db and 
target db. Typical statement would be: 
 
  - db2 connect to db1 with code page A 
  - db2 declare cursor db2 (with code page B) for select * from 
tab 
  - db2 load from cursor insert into tab 
 
The crash will happen with the following stack: 
 
  0x09000000AE0D485C sqldFormatLobLongCol + 0xAFC 
  0x09000000AE0D8B54 sqluLoadFormatFixedVar + 0xD34 
  0x09000000AE0CE738 sqluFormatDMRec + 0x1B38 
  0x09000000AE08E0E4 sqluGetAndFormatRecords + 0x30E4 
  0x09000000AE087590 iRun + 0x710 
  0x09000000ADF11C94 sqluLoadEDUDriver + 0x534 
  0x09000000ABCBB44C sqloEDUEntry + 0x32C
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users who use LOAD FROM CURSOR and need codepage         * 
* conversion for LOB data.                                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fixpack 10 or higher.             * 
****************************************************************
Local-Fix:
Try to use the same code page in both source db and target db 
when performing the load from cursor.
Lösung
The problem is firstly fixed in DB2 Version 9.7 Fixpack 10.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
22.10.2013
28.07.2015
28.07.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP10
Problem behoben lt. FixList in der Version
9.7.0.10 FixList