IBM Support

IC90915: DB2 CAN TRAP IN SQLNO_ZZ_STARJN_COMPUTE_INDEX_QUNS_REFD

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error 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
    

Local fix

  • db2set DB2_REDUCED_OPTIMIZATION="STAR_DETECTION IXA_ONLY"
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version  10.1 Fix Pack 3.                     *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version  10.1 Fix Pack 3.
    

Temporary fix

  • See Local Fix
    

Comments

APAR Information

  • APAR number

    IC90915

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-03-18

  • Closed date

    2013-10-01

  • Last modified date

    2013-10-01

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC95445

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RA10 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 10.1

Reference #: IC90915

Modified date: 01 October 2013


Translate this page: