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> |
