DB2 - Problembeschreibung
Problem IT06815 | Status: Geschlossen |
WHEN LOADING DATA INTO A COLUMN-ORGANIZED TABLE, INSTANCE MAY CRASH | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
When loading data into a column-organized table, instance may crash with following stack info. (Note that load collects statistics by default for column organized tables, but this problem only applies when we are collecting COLUMN GROUP statistics.) <StackTrace> -------Frame------ ------Function + Offset------ 0x000000000000F488 ?unknown + 0x0 0x090000003AC42DCC sqldProcessOneColHighLowKey__FP10SQLD_TSTATP10SQLD_CSTATP10sqlz_ valueP12sqld_sortkey + 0x198 0x090000003680DE28 sqldtcst__FP10SQLD_TSTATUll + 0x2320 0x09000000399C9374 sqlu_tcst__FP10SQLD_TSTATP18SQLU_DMRECORD_LISTUi + 0x164 0x09000000399ADE88 sqluCollectCDEStatsTFmt__FP13SQLUCACB_TYPEP17SQLU_FORMATTER_CB + 0x59C 0x09000000399A1EEC sqluGetAndFormatRecords__FP13SQLUCACB_TYPEP17SQLU_FORMATTER_CBUi PPUciP10sqlz_valuePUcPP10SQLD_VALUET8Pi + 0x24DC 0x09000000399B8320 iRun__14sqluCFormatterFv + 0x17A8 0x09000000387A8048 sqluLoadEDUDriver__FPUcUi + 0xA40 0x0900000035ECD09C sqloEDUEntry + 0x4AC </StackTrace> | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 10.5 FP7 * **************************************************************** | |
Local-Fix: | |
1. use 'STATISTICS NO' option to run load 2. Or use CPU_PARALLELISM=1 to run load | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 28.01.2015 21.01.2016 21.01.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |