IBM Support

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

A fix is available

Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

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
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback