IBM Support

IT27202: SPECIFIC MQT DEFINITION MAY LEAD TO DB2 ABEND WITH SIG11

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Under rare circumstances, compilation of an immediate MQT that
    references an alias may cause DB2 abnormal termination with the
    following stack:
    
    <StackTrace>
    ##### Object: /opt/IBM/db2/V9.5FP10/lib64/libdb2e.so.1
    __1cWsqlnq_propPhaseRequestPclean_incrMaint6MpnJsqlnq_qun_pnNsql
    nq_memPool__i_(0x7fffffff565bbe60,0x0,0x7fffffff56370080,0x7ffff
    fff5655ccc8,0x7fffffff7f9814e0,0x0) + 0x94 //1382
    __1cZsqlns_mst_propagate_phase6FpnWsqlnq_propPhaseRequest_rpnPsq
    lnq_incrMaint__i_(0x7fffffff565bbe60,0x7fffffff69bf2aa0,0x7,0x1a
    180000,0x7fffffff7ec4ab38,0x7fffffff562e8cf8) + 0x8a8
    __1cZsqlns_mst_propagate_phase6FpnWsqlnq_propPhaseRequest_rpnPsq
    lnq_incrMaint__i_(0x7fffffff565bbe60,0x7fffffff69bf2d00,0x0,0x1a
    180000,0x7fffffff7ec4ab38,0x7fffffff565ab138) + 0x5c8
    __1cYsqlns_compile_incr_maint6FrpnJsqlnq_qtb_11nTsqlnq_maint_con
    text_iri_i_(0x7fffffff69bf2d00,0x7fffffff565a7328,0x7fffffff565a
    b138,0x0,0x7fffffff562fbb70,0x7fffffff69bf2df4) + 0x69c
    __1cUsqlns_compile_an_mst6FpnUsqlnq_multipart_name_pnJsqlnq_qtb_
    nTsqlnq_maint_context__i_(0x7fffffff563104c0,0x7fffffff565a5648,
    0x0,0x0,0x0,0x7fffffff0ca20080) + 0x290
    __1cRsqlns_compile_mst6FpnJsqlnq_qur__i_(0x7fffffff565a4ba0,0x20
    000,0x2,0x0,0x0,0x7fffffff7ec4ab38) + 0x424
    __1cVsqlns_exp_constraints6FpnJsqlnq_qur__i_(0x7fffffff565a4ba0,
    0x0,0x0,0x7fffffff69bf3050,0x0,0x0) + 0x504
    __1cJsqlns_qgs6FpnJsqlnq_qur_nRsqlnq_requestType_pc_i_(0x7ffffff
    f565a4ba0,0x9,0x7fffffff0ca20080,0xad000,0x0,0x7fffffff7ec4ab38)
    + 0x2f0
    __1cKsqlnn_cmpl6FpnIsqeAgent_pnLsqlrrstring_hnRsqlnn_compileMode
    _hpnOsqlrr_cmpl_env_iippnJsqlnq_qur__i_(0x202f12d40,0x7fffffff69
    bf5578,0x7fffffff565b77e8,0x19880000,0x7fffffff0ca20080,0x7fffff
    ff56311240) + 0x4f58
    __1cKsqlnn_cmpl6FpnIsqeAgent_pnLsqlrrstring_hnRsqlnn_compileMode
    _hpnOsqlrr_cmpl_env__i_(0x202f12d40,0x7fffffff69bf5578,0x1,0x2,0
    x9,0x7fffffff56314d40) + 0x30
    

Local fix

  • Replace the references to aliases with direct references to the
    corresponding base tables in the MQT definition.
    
    Change definition:
    
    CREATE TABLE LT.MQT_TAB AS (
    	SELECT ...
    	FROM LA.TABA1 AS TAA1, LA.TABA1 AS TAA2, LA.TABA2 AS TBB1,
    LA.TABA2 AS TBB2
    	WHERE ...
    )
    
    to:
    
    CREATE TABLE LT.MQT_TAB AS (
    	SELECT ...
    	FROM LA_LT.TABA1 AS TAA1, LA_LT.TABA1 AS TAA2, LA_LT.TABA2 AS
    TBB1, LA_LT.TABA2 AS TBB2
    	WHERE ...
    )
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 version 11.1.4.7                              *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 version 11.1.4.7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT27202

  • 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-12-05

  • Closed date

    2022-04-17

  • Last modified date

    2022-04-17

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

    IV53304

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

    IT39354

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