IBM Support

IT24568: DB2 MAY ABEND WHILE COMPILING A QUERY CONTAINING COMMON-TABLE-EXPRESSIONS

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • DB2 may terminate abnormally when compiling a query that
    contains common-table-expressions. An example stack trace is
    seen below:
    
    ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm
    ossDumpStackTraceV98
    OSSTrapFile6dumpExEmiP7siginfoPvm
    sqlo_trce
    sqloEDUCodeTrapHandler
    sqlnoSmpDetermineDegreeP20SQLNO_SMP_POSTOPT_CBP9sqlnq_qurP19sqln
    o_plan_operator
    sqlnoSmpPostPassMain
    sqlno_final_phaseP13sqlno_globals
    sqlno_exeP9sqlnq_qur
    sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sqlrr_
    cmpl_env
    sqlra_compile_varP8sqlrr_cbP14sqlra_cmpl_envPhitiiiiiP14SQLP_LOC
    K_INFOP16sqlra_cached_varPiS5_Pb
    sqlra_find_varP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idjjPhj
    thP14sqlra_cmpl_env15sqlra_fill_modePiiS8_iiiS8_P14SQLP_LOCK_INF
    OPP16sqlra_cached_varS8_bSA_Pb
    sqlra_get_varP8sqlrr_cbiibPbS1_
    sqlrr_prepareP14db2UCinterfaceP16db2UCprepareInfo
    sqljs_ddm_prpsqlsttP14db2UCinterfaceP13sqljDDMObject
    sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCint
    erface
    sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb
    sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T
    sqeAgent6RunEDUEv
    sqzEDUObj9EDUDriverEv
    sqloEDUEntry
    clone
    </Description>
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher                *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT24568

  • 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-03-28

  • Closed date

    2020-01-28

  • Last modified date

    2020-01-28

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

    IT24567

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"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:
28 January 2020