IBM Support

IT24722: DB2 MIGHT ABEND WHEN RUNNING QUERIES CONTAINING CASE EXPRESSIONSAND SCALAR AGGREGATIONS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 might trap when users run a query that has the following
    characteristics:
    1. the query has multiple levels of SELECT
    2. one of the lower level select lists has at least one CASE
    expression
    3. the CASE expression contains scalar aggregations
    4. the CASE expression is not referenced in higher level SELECT
    lists
    
    
    <StackTrace>
    -------Frame------ ------Function + Offset------
    0x09000000467D194C sqlnd_qtb_pda__FRP9sqlnq_qtbT1iT3 + 0xAC
    0x09000000467D2700 sqlnd_qtb_pda__FRP9sqlnq_qtbT1iT3 + 0xE60
    0x09000000467D2700 sqlnd_qtb_pda__FRP9sqlnq_qtbT1iT3 + 0xE60
    0x09000000467D2700 sqlnd_qtb_pda__FRP9sqlnq_qtbT1iT3 + 0xE60
    0x09000000467D2700 sqlnd_qtb_pda__FRP9sqlnq_qtbT1iT3 + 0xE60
    0x09000000467D2700 sqlnd_qtb_pda__FRP9sqlnq_qtbT1iT3 + 0xE60
    0x09000000467D2700 sqlnd_qtb_pda__FRP9sqlnq_qtbT1iT3 + 0xE60
    0x09000000467D1700 sqlnd_qtb_pda__FRP9sqlnq_qtbi + 0x80
    0x09000000467D01F8 sqlnd_main__FP9sqlnq_quri + 0x378
    0x0900000046D85308
    sqlnr_after_prep1__FP10sqlnr_qrwaPiP14sqlnr_progress + 0x228
    0x09000000468DB198
    sqlnr_comp__FPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_progres
    s + 0x218
    0x09000000468DB544
    sqlnr_seq__FPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass +
    0xC4
    0x09000000468DBA48 sqlnr_rcc__FiP10sqlnr_qrwaPiP14sqlnr_progress
    + 0x308
    0x0900000046D86ADC sqlnr_exe__FP9sqlnq_qur + 0x6FC
    0x09000000475DD3E4
    sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
    lrr_cmpl_enviT7PP9sql
    nq_qur + 0x7404
    0x09000000475D5F68
    sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
    lrr_cmpl_env + 0x28
    0x0900000046422F5C
    sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_
    LOCK_INFOP16sqlra_cac
    hed_varPiT11_Pb + 0xBDC
    0x0900000043DF4400
    sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi
    T4PUcT4UsUcP14sqlra_c
    mpl_env15sqlra_fill_modePiiT12_N313_T12_P14SQLP_LOCK_INFOPP16sql
    ra_cached_varT12_bT19_Pb + 0xA60
    0x090000004653329C sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0xBFC
    0x09000000453134FC
    sqlrr_prepare__FP14db2UCinterfaceP16db2UCprepareInfo + 0x57C
    0x090000004A038DB0
    sqljs_ddm_prpsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x12B0
    0x0900000049FC5610
    sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
    interface + 0x2B0
    0x0900000049FC8664
    sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
    0x2264
    0x0900000049F94F9C
    IPRA.$sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xE9C
    0x0900000049F9D6B4
    sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4
    0x0900000049F93060
    IPRA.$sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x13E0
    0x0900000049F904B4 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
    0x334
    0x090000004325DBC0 RunEDU__8sqeAgentFv + 0xB60
    0x0900000043240640 EDUDriver__9sqzEDUObjFv + 0x300
    0x090000004312F614 sqloEDUEntry + 0x374
    </StackTrace>
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.1.4.7                                          *
    ****************************************************************
    

Problem conclusion

  • Upgrade to 11.1.4.7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT24722

  • 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-04-13

  • Closed date

    2022-04-17

  • Last modified date

    2022-04-17

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

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

    IT38829

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 May 2022