IBM Support

IT23742: DB2 MIGHT ABEND WHEN RUNNING QUERIES CONTAINING OR PREDICATES AND EXISTS PREDICATES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 might abend when queries contain:
    1. OR predicates
    2. EXISTS/IN/NOT EXISTS predicates are ORed with local
    predicates
    3. local predicates containing EXISTS/IN/NOT EXISTS sub-queries
    
    When trap occurs, the following crashed stack can be observed:
    <StackTrace>
    -------Frame------ ------Function + Offset------
    0x09000000176758E8
    sqlno_analyze_countingSQ__FP13sqlno_globalsP9sqlno_sfbP9sqlno_qt
    bP9sqlnq_pidP9sqlno_prd13SQLNN_BOOLEAN + 0x3A8
    0x0900000017675ED0
    sqlno_finish_tree_walk__FP13sqlno_globalsP9sqlno_sfbP9sqlno_qtbP
    9sqlnq_pidP9sqlno_prdP9sqlnq_qunT613SQLNN_BOOLEAN + 0x2F0
    0x0900000017676170
    sqlno_finish_tree_walk__FP13sqlno_globalsP9sqlno_sfbP9sqlno_qtbP
    9sqlnq_pidP9sqlno_prdP9sqlnq_qunT613SQLNN_BOOLEAN + 0x590
    0x0900000017676170
    sqlno_finish_tree_walk__FP13sqlno_globalsP9sqlno_sfbP9sqlno_qtbP
    9sqlnq_pidP9sqlno_prdP9sqlnq_qunT613SQLNN_BOOLEAN + 0x590
    0x0900000017676170
    sqlno_finish_tree_walk__FP13sqlno_globalsP9sqlno_sfbP9sqlno_qtbP
    9sqlnq_pidP9sqlno_prdP9sqlnq_qunT613SQLNN_BOOLEAN + 0x590
    0x090000001767B120
    sqlno_analyze_relop__FP13sqlno_globalsP9sqlno_sfbP9sqlno_qtbP9sq
    lnq_pidP9sqlno_prd + 0x900
    0x090000001767E5E4
    sqlno_analyze_pred_expr__FP13sqlno_globalsP9sqlno_sfbP9sqlno_qtb
    P9sqlnq_pidPi + 0x584
    0x090000001767F3D8
    sqlno_analyze_ANDORNOT__FP13sqlno_globalsP9sqlno_sfbP9sqlno_qtbP
    9sqlnq_pidPi + 0x318
    0x090000001767E590
    sqlno_analyze_pred_expr__FP13sqlno_globalsP9sqlno_sfbP9sqlno_qtb
    P9sqlnq_pidPi + 0x530
    0x090000001767F3D8
    sqlno_analyze_ANDORNOT__FP13sqlno_globalsP9sqlno_sfbP9sqlno_qtbP
    9sqlnq_pidPi + 0x318
    0x090000001767E590
    sqlno_analyze_pred_expr__FP13sqlno_globalsP9sqlno_sfbP9sqlno_qtb
    P9sqlnq_pidPi + 0x530
    0x0900000017688408
    sqlno_assign_optprd__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_oprP9sq
    lnq_prdPi + 0x4A8
    0x0900000017688D28
    sqlno_assign_prd__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_oprP9sqlnq
    _prd + 0x168
    0x0900000014F185B8
    sqlno_call_sf__FP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvT4i13SQLN
    N_BOOLEAN + 0x338
    0x0900000014F1C758
    sqlno_each_opr__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_o
    pr + 0x3B8
    0x0900000017672470
    sqlno_call_sf__FP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvT4i13SQLN
    N_BOOLEAN + 0x370
    0x0900000017672A98
    sqlno_assign_walk_quns_and_ff__FP13sqlno_globalsP9sqlno_sfbP9sql
    nq_oprP9sqlnq_qun + 0x378
    0x0900000014F185B8
    sqlno_call_sf__FP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvT4i13SQLN
    N_BOOLEAN + 0x338
    0x0900000014F1CB90
    sqlno_each_opr__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_o
    pr + 0x7F0
    0x0900000017672470
    sqlno_call_sf__FP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvT4i13SQLN
    N_BOOLEAN + 0x370
    0x0900000017672A98
    sqlno_assign_walk_quns_and_ff__FP13sqlno_globalsP9sqlno_sfbP9sql
    nq_oprP9sqlnq_qun + 0x378
    0x0900000014F185B8
    sqlno_call_sf__FP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvT4i13SQLN
    N_BOOLEAN + 0x338
    0x0900000014F1CB90
    sqlno_each_opr__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_o
    pr + 0x7F0
    0x0900000017672470
    sqlno_call_sf__FP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvT4i13SQLN
    N_BOOLEAN + 0x370
    0x0900000017672A98
    sqlno_assign_walk_quns_and_ff__FP13sqlno_globalsP9sqlno_sfbP9sql
    nq_oprP9sqlnq_qun + 0x378
    0x0900000014F185B8
    sqlno_call_sf__FP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvT4i13SQLN
    N_BOOLEAN + 0x338
    0x0900000014F1CB90
    sqlno_each_opr__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_o
    pr + 0x7F0
    0x0900000014F185B8
    sqlno_call_sf__FP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvT4i13SQLN
    N_BOOLEAN + 0x338
    0x0900000014F1D378
    sqlno_top_qtb__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_qurP9sqlnq_qt
    b + 0x158
    0x0900000014F185B8
    sqlno_call_sf__FP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvT4i13SQLN
    N_BOOLEAN + 0x338
    0x0900000014F1D964
    sqlno_each_qur__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_qurT3 +
    0x344
    0x0900000014F185B8
    sqlno_call_sf__FP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvT4i13SQLN
    N_BOOLEAN + 0x338
    0x0900000014F18A08
    sqlno_scan_qgm__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_qur + 0x1A8
    0x0900000012A97A40
    sqlno_prep_phase__FP13sqlno_globalsP9sqlnq_qur + 0xC40
    0x0900000012A9AEB0 sqlno_exe__FP9sqlnq_qur + 0x1C50
    0x0900000012A7AC30
    sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
    lrr_cmpl_enviT7PP9sqlnq_qur + 0x12D90
    0x0900000012A8682C
    sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
    lrr_cmpl_env + 0x8C
    0x0900000011898768
    sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_
    LOCK_INFOP16sqlra_cached_varPiT11_Pb + 0x1F88
    0x0900000012678130
    sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi
    T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_P14
    SQLP_LOCK_INFOPP16sqlra_cached_varT12_bT19_Pb + 0x1130
    0x0900000010ADABB8 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0x38B8
    0x0900000010962164
    sqlrr_prepare__FP14db2UCinterfaceP16db2UCprepareInfo + 0x444
    0x0900000017CBEAAC
    sqljs_ddm_prpsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x20C
    0x09000000108FD704
    sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
    interface + 0x284
    0x09000000108FBFB0
    sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
    0x290
    0x09000000108901D4 sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb +
    0x6D4
    0x0900000010892B10
    sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x1D0
    0x090000001089A418
    sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x5B8
    0x090000001089C8EC sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
    0x2EC
    0x090000000C785D1C RunEDU__8sqeAgentFv + 0x47C
    0x090000000C742DF8 EDUDriver__9sqzEDUObjFv + 0x238
    0x090000000C74315C sqlzRunEDU__FPcUi + 0x3C
    0x090000000C4D6E98 sqloEDUEntry + 0x778
    </StackTrace>
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to the latest fix pack                               *
    ****************************************************************
    

Problem conclusion

  • The problem is first fixed in V11.1 mode pack 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT23742

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-01-15

  • Closed date

    2018-03-15

  • Last modified date

    2018-03-15

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 March 2018