|
Problem IC90915
|
Status: Closed |
DB2 CAN TRAP IN SQLNO_ZZ_STARJN_COMPUTE_INDEX_QUNS_REFD |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
DB2 can trap when compiling an SQL statement that meets all of
the
conditions below:
(1) The query fits the required criteria for zigzag join. Refer
to the topic "Ensuring that queries fit the required criteria
for the zigzag join" in DB2 InfoCentre for details about the
criteria.
(2) The fact table has an XML column, and there is an XML index
on the XML column.
The stack can look like the following:
sqlno_zz_starjn_compute_index_quns_refd__FP13sqlno_globalsP9sqln
o_qtbP10sqlno_apcbP11sqlno_tableiP24sqlno_zz_starjn_qun_infoP9sq
lnq_attP10sqlno_isetUiT5P16sqlno_listheader + 0x29C
sqlno_zz_starjn_compute_fact_indexes__FCP13sqlno_globalsCP9sqlno
_qtbCP10sqlno_apcbC9sqlno_setCbP9sqlno_setP24sqlno_zz_starjn_qun
_infoPb + 0x988
sqlno_zz_starjn_compute_star__FCP13sqlno_globalsCP9sqlno_qtbCP10
sqlno_apcbCPP22sqlno_adjacency_matrixCbT5C9sqlno_setCP24sqlno_zz
_starjn_qun_infoCP9sqlno_setT9T8CPb + 0x4DC
sqlno_zz_starjn_init__FCP13sqlno_globalsCP9sqlno_qtb + 0x310
sqlno_prop_compute_ff_adjustments__FP13sqlno_globalsP9sqlno_qtb
+ 0x1E8
sqlno_plan_begin_opr__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_opr +
0x3C8
sqlno_each_opr__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_o
pr + 0x230
sqlno_walk_qun__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_oprP9sqlnq_q
un + 0x124
sqlno_each_opr__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_o
pr + 0x42C
sqlno_walk_qun__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_oprP9sqlnq_q
un + 0x124
sqlno_each_opr__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_o
pr + 0x42C
sqlno_walk_qun__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_oprP9sqlnq_q
un + 0x124
sqlno_each_opr__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_o
pr + 0x42C
sqlno_walk_qun__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_oprP9sqlnq_q
un + 0x124
sqlno_each_opr__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_o
pr + 0x42C
sqlno_walk_qun__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_oprP9sqlnq_q
un + 0x124
sqlno_each_opr__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_o
pr + 0x42C
sqlno_walk_qun__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_oprP9sqlnq_q
un + 0x124
sqlno_each_opr__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_o
pr + 0x42C
sqlno_walk_qun__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_oprP9sqlnq_q
un + 0x124
sqlno_each_opr__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_o
pr + 0x42C
sqlno_top_qtb__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_qurP9sqlnq_qt
b + 0x104
sqlno_each_qur__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_qurT3 +
0x2DC
sqlno_scan_qgm__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_qur + 0x2B8
sqlno_planning_scan__FP13sqlno_globalsP9sqlnq_quri + 0xC0
sqlno_planning_phase__FP13sqlno_globalsP9sqlnq_quriT3 + 0xC44
sqlno_exe__FP9sqlnq_qur + 0x7FC
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_enviT7PP9sqlnq_qur + 0x188
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_env + 0x28
sqlrr_cmpl__FP8sqlrr_cbP11sqlrrstrings17sqlnn_compileModeUcP5sql
daPiPUiPP9sqlri_shdP11compileInfo + 0x5EC
sqlrr_compile__FP14db2UCinterfaceP11compileInfo + 0x964
addStatement__13psmPackageGenFPciT2P18psmPackageVariableT2RUs +
0x380
makeSection__14psmQueryStringFP19psmPVMCodeGeneratoriUsR12pvmQue
ryDesc + 0x280
generate__19psmPVMCodeGeneratorFP23psm_DECLARE_CURSOR_node +
0x32C
generate__27@75@psm_DECLARE_CURSOR_nodeFP16psmCodeGenerator +
0x70
generate__19psmPVMCodeGeneratorFP14psm_block_node + 0x2AC
generate__18@75@psm_block_nodeFP16psmCodeGenerator + 0x70
generate__19psmPVMCodeGeneratorFP18psm_procedure_node + 0x2A0
generate__22@75@psm_procedure_nodeFP16psmCodeGenerator + 0x70
genProgram__19psmPVMCodeGeneratorFP10psmProgram + 0x3CC
psm_generate_PVM__8psm_ctrlFv + 0x27C
psm_gen_program__FP8psm_ctrl + 0x82C
sqlnq_create_proc_end__FP12sqlnq_string + 0x62C
sqlnq_proc_create_stmt__FPP8stknode_i10actiontypePUcP3loc +
0xCA0
sqlnp_smactn__FP8sqlnp_cbi + 0x134
sqlnp_parser__FP8sqlnp_cb + 0x4FC
sqlnp_main__FP12sqlnq_stringbP3locPP9sqlnq_qur + 0x258
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_enviT7PP9sqlnq_qur + 0x560
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_env + 0x28
sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_
LOCK_INFOP16sqlra_cached_varPi + 0x778
sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi
T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_P14
SQLP_LOCK_INFOPP16sqlra_cached_varT12_b + 0x8AC
sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0x1A20
sqlri_ddl_get_section__FP8sqlrr_cb + 0x68
sqlri_ddl_common__FP8sqlrr_cb + 0x474
sqlriddl__FP8sqlrr_cb + 0x38
sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x24
sqlrr_execute_immediate__FP8sqlrr_cbi + 0x4F8
sqlrr_execimmd__FP14db2UCinterfaceP16db2UCprepareInfo + 0x4E8
sqljs_ddm_excsqlimm__FP14db2UCinterfaceP13sqljDDMObject + 0xDB8
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0x3C
.sqljsParse.fdpr.clone.102__FP13sqljsDrdaAsCbP14db2UCinterfaceP8
sqeAgentb + 0x13A4
@73@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x280
@73@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4
@73@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x4E8
sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0x21C
RunEDU__8sqeAgentFv + 0x584
EDUDriver__9sqzEDUObjFv + 0x13C
sqlzRunEDU__FPcUi + 0x10
sqloEDUEntry + 0x264 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.1 Fix Pack 3. *
**************************************************************** |
| Local Fix: |
db2set DB2_REDUCED_OPTIMIZATION="STAR_DETECTION IXA_ONLY" |
| available fix packs: |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 Version 10.1 Fix Pack 3. |
| Workaround |
See Local Fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC95445
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.03.2013
01.10.2013
01.10.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
