DB2 - Problembeschreibung
Problem IC67166 | Status: Geschlossen |
A LOAD OPERATION FROM CURSOR WHICH CONSISTS OF DATA WITH BAD CHARACTERS CAUSES DB2 TO CRASH. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 | |
Problembeschreibung: | |
A load operation happens between 2 tables with different datatypes - CHAR/VARCHAR and GRAPHIC/VARGRAPHIC respectively. The LOAD from CURSOR does implicit codepage conversion due to loading from CHAR columns (codepage 1208) to GRAPHIC columns (codepage 1200). When bad character data is hit during this load operation , the load is unable to handle this error condition which leads the DB2 server to crash. This problem can also occur between 2 tables with the same datatypes, if they are from different databases with different codepages, and the LOAD from CURSOR DATABASE does implicit codepage conversion. The stack trace of the trapping process looks similar to this: ... (maybe some trap handling function here) (maybe a _memmove or an unknown function here) _ZN16sqluCCrossParser11zColConvertEbPPj + 0xbb0 _ZN16sqluCCrossParser12zParseColumnEbPcmPmPb + 0x1dc0 _Z8sqlulxrrP8SQLD_TCBPP10SQLD_VALUEP8sqlulxwa + 0x600 _Z23sqluGetAndFormatRecordsP8sqlulacbP13SQLUCACB_TYPEP17SQLU_FOR MATTER_CBjPPhiP10sqlz_valueS5_PP10SQLD_VALUESB_Pi + 0x13b0 _Z8sqluldatPhj + 0xce0 ... | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users on DB2 V9.1 doing Load of char into graphic * **************************************************************** * PROBLEM DESCRIPTION: * * A LOAD OPERATION FROM CURSOR WHICH CONSISTS OF DATA WITH * * BAD CHARACTERS CAUSES DB2 TO CRASH. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V9.1 fp10 to avoid the crash * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows | |
Lösung | |
Fixed in DB2 V9.1 fp10. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 11.03.2010 14.06.2011 14.06.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.1.FP10 | |
Problem behoben lt. FixList in der Version | |
9.1.0.10 |