|
Problem IT06815
|
Status: Closed |
WHEN LOADING DATA INTO A COLUMN-ORGANIZED TABLE, INSTANCE MAY CRASH |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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 |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.01.2015
21.01.2016
21.01.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.7
|
 |
