DB2 FOR LUW / DB2FORLUW / A50 - DB2

When doing advise indexes on the table that has partitioning 
predicate ,  you may got -901 'bad ixm LISTOF' error , and the 
following stack information can also been find in db2diag.log 
file . 
Compiler error stack for rc = -2144272209: 
sqlnn_cmpl[420] 
sqlng_main[2791] 
sqlng_main[1657] 
sqlng_build_thread[10] 
sqlng_process_return_op[50] 
sqlng_process_pipe_op[30] 
sqlng_process_mate_op[1735] 
sqlng_process_delete_op[10] 
sqlng_process_pipe_op[30] 
sqlng_process_mate_op[1735] 
sqlng_process_mergejoin_op[30] 
sqlng_build_thread[10] 
sqlng_process_iscan_op[38] 
sqlng_build_TA_op[400] 
sqlng_handle_PBT_in_build_[100] 
sqlng_build_PBT_op[10] 
sqlng_build_PBT_obj[800] 
sqlng_build_PBT_IDX_ARRAYS[110] 
Besides , you can also get  the following stack information for 
 the problematic EDU 
<StackTrace> 
-------Frame------ ------Function + Offset------ 
0x09000000005CAC54 pthread_kill + 0xD4 
0x090000000370CF88 sqloDumpEDU + 0x74 
0x090000000370DE4C sqldDumpContext__FP8sqeAgentiN42PCcPvT2 + 
0x11C 
0x090000000370DC64 
sqldDumpContext__FP8sqeAgentiN42PCcPvT2@glueABB + 0x94 
0x0900000003A3FE8C sqlrr_dump_ffdc__FP8sqlrr_cbiT2 + 0x350 
0x0900000002EE020C sqlzeDumpFFDC__FP8sqeAgentUiP5sqlcai + 0x24 
0x0900000002EDFFB8 sqlzeSqlCode__FP8sqeAgentUiUlT2P5sqlcaiUsPc 
+ 0x120 
0x0900000002EDFCCC sqlnn_erds__FiN41e + 0x124 
0x0900000004A780C0 
sqlng_build_PBT_IdxArrays__FP9sqlng_blkP14sqlng_scan_blkP9sqlri_ 
taoP11sqlriPBTObj + 0xD10 
0x0900000004A743D8 
sqlng_build_PBT_obj__FP9sqlng_blkP14sqlng_scan_blkUlP9sqlri_taoP 
10sqlri_iudoPP11sqlriPBTObj + 0x8C8 
0x0900000004A739BC 
sqlng_build_PBT_op__FP9sqlng_blkP14sqlng_scan_blkUlP9sqlri_taoP1 
0sqlri_iudo + 0xAC 
0x0900000004A7B334 
sqlng_handle_PBT_in_build_TA_op__FP9sqlng_blkP14sqlng_scan_blkP9 
sqlri_taoT3 + 0x538 
0x0900000003F7E52C 
sqlng_build_TA_op__FP9sqlng_blkP14sqlng_scan_blkP9sqlno_qtb + 
0x205C 
0x0900000003F9E7CC 
sqlng_process_iscan_op__FP9sqlng_blkP19sqlno_plan_operator + 
0x63C 
0x0900000003F562B4 
sqlng_build_thread__FP9sqlng_blkP14sqlng_thd_ctrl + 0x158 
0x0900000003F989A8 
sqlng_process_mergeJoin_op__FP9sqlng_blkP19sqlno_plan_operator 
+ 0x488 
0x0900000003FA6EDC 
sqlng_process_mate_op__FP9sqlng_blkP19sqlno_plan_operator + 
0x480 
0x0900000003FAE53C 
sqlng_process_pipe_op__FP9sqlng_blkP19sqlno_plan_operator + 
0x368 
0x090000000450E30C 
sqlng_process_delete_op__FP9sqlng_blkP19sqlno_plan_operator + 
0x374 
0x0900000003FA6EDC 
sqlng_process_mate_op__FP9sqlng_blkP19sqlno_plan_operator + 
0x480 
0x0900000003FAE53C 
sqlng_process_pipe_op__FP9sqlng_blkP19sqlno_plan_operator + 
0x368 
0x0900000003FAEFC8 
sqlng_process_return_op__FP9sqlng_blkP19sqlno_plan_operator + 
0x854 
0x0900000003F562B4 
sqlng_build_thread__FP9sqlng_blkP14sqlng_thd_ctrl + 0x158 
0x0900000004A2D994 sqlng_main__FP9sqlnq_qur + 0x21A4 
0x0900000004A644A0 sqlng_main__FP9sqlnq_qur@glue1255 + 0x70 
0x090000000281A454 
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq 
lrr_cmpl_enviT7PP9sqlnq_qur + 0x2A98 
0x0900000002ECF800 
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq 
lrr_cmpl_env + 0x24 
0x0900000002E755C4 
sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P16sqlra 
_cached_varPiPUl + 0x610 
0x0900000002E74240 
sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi 
T4PUcT4UsUcP14sqlra_cmpl_enviPiT11_T12_N311_T12_P14SQLP_LOCK_INF 
OPP16sqlra_cached_varT12_PUlb + 0x404 
0x0900000002E73CAC sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0x444 
0x0900000003323728 
sqlrr_prepare__FP14db2UCinterfaceP16db2UCprepareInfo + 0x138 
0x0900000002DDDFF8 
sqljs_ddm_prpsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0xAF0 
0x090000000290EEB4 
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC 
interface + 0x10C 
0x0900000002F76DE0 
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface - 0x124 
0x0900000002F78730 
@63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x1D8 
0x09000000030F6558 
@63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x98 
0x09000000030F63C8 
@63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0xE0 
0x09000000030F613C sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 
0xD8 
0x09000000030F7E00 RunEDU__8sqeAgentFv + 0x11C 
0x0900000003102748 EDUDriver__9sqzEDUObjFv + 0x78 
0x090000000308F550 sqloEDUEntry + 0x57C 
</StackTrace> 
The issue can only occur when db2advis is used in conjunction 
with a UNION ALL that is eligible for parameterization .

**************************************************************** 
* USERS AFFECTED:                                              * 
* Anyone affected by the issue                                 * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to db2_v105fp7                                       * 
****************************************************************

Turning off union parameterization with following command to 
address this problem: 
db2set DB2_UNION_OPTIMIZATION="PARAMETERIZE OFF" 
db2stop 
db2start

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

09.07.2015
21.01.2016
21.01.2016