|
Problem IT09986
|
Status: Closed |
SQL0901N "BAD IXM LISTOF" RETURNED WHEN RUNNING DB2ADVIS |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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 . |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Anyone affected by the issue *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* upgrade to db2_v105fp7 *
**************************************************************** |
| Local Fix: |
Turning off union parameterization with following command to
address this problem:
db2set DB2_UNION_OPTIMIZATION="PARAMETERIZE OFF"
db2stop
db2start |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.07.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
|
 |
