IBM Support

IC98037: INSTANCE MIGHT TRAP WITH SIGNAL 11 IN SQLR_CONSTRUCT_NEW_PD

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • An instance trap might occur because of a signal 11 caught in
    sqlr_construct_new_pd. The conditions to fall into this issue
    are the following, when AUTO_STMT_RUNSTATS is enabled :
    
    (1) There hasn't been any runstats on the table, but Real Time
    Statistics (RTS) has fabricated statistics for the table.
    (2) A statistics profile exists for the table.
    (3) RTS tries to fabricate new statistics on this table, then
    DB2 can trap here.
    
    The stack in the generated FODC directory will show something
    similar to the following :
    
    <StackTrace>
    ##### Object: /platform/sun4u-opl/lib/sparcv9/libc_psr.so.1
    _memcpy(0x0,0xfffffffebef9e000,0xfffffff6769081a0,0xfffffe88,0xf
    ffffe88,0x40) + 0x2dc
    ##### Object: /opt/IBM/db2/V9.7/lib64/libdb2e.so.1
    __1cVsqlr_construct_new_pd6FpnIsqlrr_cb_ppnIsqlrg_pd_pnKSQdDLD_T
    STAT_ipb_i_(0x0,0xfffffffebef9e000,0xfffffff6769081a0,0xfffffe88
    ,0xfffffe88,0x40) + 0x86c4
    __1cVsqlr_construct_new_pd6FpnIsqlrr_cb_ppnIsqlrg_pd_pnKSQdDLD_T
    STAT_ipb_i_(0x71e,0xfffffff67690f500,0x18900000,0xfffffff6769081
    a0,0x0,0x40) + 0xa764
    __1cUsqlr_update_catalogs6FpnIsqlrr_cb_pnLsqlrrstring_3pnKSQdDLD
    _TSTAT_ippnKSQdDLD_ISTAT_pippnIsqlrg_pd_pnFsqlca_ipnOsqlrg_nodec
    ard_HILppc_i_(0x0,0x0,0xfffffff951feb150,0x4400,0xffffffff7b761d
    65,0xfffffff951ff05a8) + 0x1424
    __1cRsqlrLocalRunstats6FpnIsqlrr_cb_pnLsqlrrstring_33CHHppnIsqlr
    g_pd_iiiipnQsqlrl_stats_cols_pphIppHIdIHppnUsqlr_runstats_result
    _9ALLHHkIIlpnRsqlrlc_stats_info_pkC_i_(0xfffffffa6a836800,0xffff
    fff951ff1698,0xfffffff951ff1688,0xc7000,0x9,0x1fc4) + 0xd160
    __1cQsqlrJitsRunstats6FpnIsqlrr_cb_pkCl3lC3lbdLLClpnRsqlrlc_stat
    s_info_3ppnIsqlrg_pd__i_(0x1,0x8,0x12,0xfffffff6c1908060,0xfffff
    ff951ff20c8,0x20) + 0x938
    __1cbDsqlno_runstats_or_fabrication6FpnNsqlno_globals_pnJsqlnq_f
    tb_nPJITS_stats_type_flnNSQdDLNN_BOOLEAN_pnDloc_pnRsqlrlc_stats_
    info_pkCppnIsqlrg_pd_pi_i_(0x0,0x4,0xfffffff951ff20c8,0x0,0x9,0x
    10) + 0x934
    __1cbNsqlno_jits_fabricate_and_async_runstats6FpnNsqlno_globals_
    pnVsqlno_int_table_stats_ib_i_(0xfffffffee7470360,0xfffffffebefa
    00b0,0x51190,0x0,0x19a80400,0xffffffff78c52fb0) + 0x1220
    __1cTsqlno_collect_stats6FpnNsqlno_globals_pnVsqlno_int_table_st
    ats_rlnNSQdDLNN_BOOLEAN__i_(0xfffffffee7470360,0xfffffffebefa00b
    0,0x2,0x0,0x0,0x0) + 0x14f0
    __1cUsqlno_int_stats_scan6FpnNsqlno_globals_nNSQdDLNN_BOOLEAN_l_
    i_(0xfffffffee7470360,0x20,0x1fc4,0xfff7,0x4e20,0x1) + 0x1c4c
    __1cJsqlno_exe6FpnJsqlnq_qur__i_(0x0,0xffffffff7c85a2c0,0xffffff
    fee7470360,0xfffffffee7460080,0x80300203400,0x0) + 0x1260
    __1cKsqlnn_cmpl6FpnIsqeAgent_pnLsqlrrstring_hnRsqlnn_compileMode
    _hpnOsqlrr_cmpl_env_iippnJsqlnq_qur__i_(0x2037161a0,0xfffffff951
    ff51d8,0x0,0x19880000,0xfffffffa6a836800,0x0) + 0x65a0
    __1cKsqlnn_cmpl6FpnIsqeAgent_pnLsqlrrstring_hnRsqlnn_compileMode
    _hpnOsqlrr_cmpl_env__i_(0x2037161a0,0xfffffff951ff51d8,0x1,0x2,0
    x9,0xfffffffebf4c1ae0) + 0x30
    __1cRsqlra_compile_var6FpnIsqlrr_cb_pnOsqlra_cmpl_env_pCiHiiiiip
    nOSQdDLP_LOCK_INFO_pnQsqlra_cached_var_pipL_i_(0xfffffffa6a83680
    0,0x16c0,0xfffffff691248560,0xffffffff7e2a9850,0x2d8,0xffffffff7
    c85a2c0) + 0x2994
    __1cOsqlra_find_var6FpnIsqlrr_cb_pnRsqlra_cached_stmt_nNsqlra_st
    mt_id_IIpCIHCpnOsqlra_cmpl_env_nPsqlra_fill_mode_pii9Aiii9ApnOSQ
    dDLP_LOCK_INFO_ppnQsqlra_cached_var_9ApLb_i_(0x0,0x1,0xfffffff6f
    4c5ee20,0x1,0x0,0xfffffff6f4c5ee58) + 0x2680
    __1cNsqlra_get_var6FpnIsqlrr_cb_iibpb2_i_(0xfffffffa6a836800,0xf
    ffffff951ff6f30,0xfffffffebfdf69e0,0xfffffffebfdf6940,0xfffffffe
    c00e1640,0xffffffff7b7b6225) + 0x1eec
    __1cWsqlrr_array_input_load6FpnOdb2UCinterface_ppnPdb2UCdiagStru
    ct_LH_i_(0xfffffffa6a836800,0xfffffff951ff71bb,0x0,0xfffffffa6fb
    004e8,0x18900000,0xfffffffa68f89560) + 0x1a00
    __1cKsqlrr_open6FpnOdb2UCinterface_pnPdb2UCCursorInfo__i_(0xffff
    fffa68f89560,0xfffffffa6fb004e8,0x5,0x1400,0xfffffffa6a836800,0x
    1) + 0x5c8
    __1cQsqljs_ddm_opnqry6FpnOdb2UCinterface_pnNsqljDDMObject__i_(0x
    fffffffa68f89560,0xfffffffa6fb04220,0xfffffffa6fb007c8,0x0,0xfff
    ffffa6fb004e8,0xfffffffa6fb04220) + 0x300
    __1cVsqljsParseRdbAccessed6FpnNsqljsDrdaAsCb_pnNsqljDDMObject_pn
    Odb2UCinterface__i_(0xfffffffa6fb00080,0xfffffff951ff7588,0xffff
    fffa68f89560,0x200c,0x2000,0x0) + 0x2d8
    __1cKsqljsParse6FpnNsqljsDrdaAsCb_pnOdb2UCinterface_pnIsqeAgent_
    b_i_(0x1,0xfffffffa68f89560,0x2037161a0,0xfffffffa6fb00e08,0x203
    719e68,0xfffffffa6fb00080) + 0x714
    __1cWsqljsSetupDrdaAsForApp6FpnNsqljsDrdaAsCb_pnOdb2UCinterface_
    b_i_(0x0,0x2037161a0,0x0,0xfffffffa68f89560,0xfffffffa6fb00080,0
    x203719e68) + 0x848
    __1cWsqljsSetupDrdaAsForApp6FpnNsqljsDrdaAsCb_pnOdb2UCinterface_
    b_i_(0x2037161a0,0xfffffffa6a7d54e0,0x1400,0xfffffffa68f89560,0x
    0,0xfffffffa6fb00080) + 0x1e0c
    __1cRsqljsDrdaAsDriver6FpnSSQdDLCC_INITSTRUCT_T__i_(0xfffffffa6f
    b00080,0x0,0xfffffff951ffff30,0xfffffffa6a7d54e0,0x2037161a0,0xf
    fffffff7c85a2c0) + 0x1074
    __1cRsqljsDrdaAsDriver6FpnSSQdDLCC_INITSTRUCT_T__i_(0x203509e20,
    0xffffffffffffffff,0x5800,0xfffffffa6b7df420,0xfffffffa6b7df420,
    0xfffffff951ffff30) + 0x1c0
    __1cIsqeAgentGRunEDU6M_v_(0x2037161a0,0x2037177e0,0x18280400,0xf
    fffffff7c85a2c0,0xffffffff7e2a9850,0x7268) + 0x884
    __1cKsqlzRunEDU6FpcI_v_(0xfffffff951ffdd20,0xffffffff7810a010,0x
    1b9d7dc,0x18d00000,0x0,0xffffffff7c85a2c0) + 0xd4
    sqloEDUEntry(0xffffffff5effd080,0xfffffff951ffff30,0x8,0xfffffff
    f7e2a98c8,0x18780000,0x0) + 0x3d4
    ##### Object: /lib/sparcv9/libc.so.1
    _thr_slot_offset(0x0,0x0,0x0,0x0,0x0,0x0) + 0x488
    </StackTrace>
    

Local fix

  • Issue runstats command to collect statistics for the table.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * specific to Real Time Statistics                             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to version 9.7 Fix Pack 10                           *
    ****************************************************************
    

Problem conclusion

  • First fixed in version 9.7 Fix Pack 10
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC98037

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-12-02

  • Closed date

    2014-11-10

  • Last modified date

    2014-11-10

  • 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

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC98037

Modified date: 10 November 2014