DB2 - Problembeschreibung
Problem IT06862 | Status: Geschlossen |
DB2 might trap while collecting statistics for indexes | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
Agent might terminate abnormally during sampled statistics collection for indexes. Trap might be caused by executing following RUNSTATS command with INDEXSAMPLE option: RUNSTATS ON TABLE <SCHEMA_NAME>.<TABLE_NAME> FOR INDEX <INDEX_NAME> ALLOW WRITE ACCESS INDEXSAMPLE SYSTEM(99.9) Following stack can be found in the trap file: _Z25ossDumpStackTraceInternalmi + 0x140 [/db2/db2iwt/db2sw/db2_v10_fp4_sb33045/lib64/libdb2osse.so] ossDumpStackTraceV98 + 0x80 [/db2/db2iwt/db2sw/db2_v10_fp4_sb33045/lib64/libdb2osse.so] _ZN11OSSTrapFile4dumpEmiP9__siginfoPv + 0x170 [/db2/db2iwt/db2sw/db2_v10_fp4_sb33045/lib64/libdb2osse.so] sqlo_trce + 0xa00 [/db2/db2iwt/db2sw/db2_v10_fp4_sb33045/lib64/libdb2e.so] sqloEDUCodeTrapHandler + 0x3b0 [/db2/db2iwt/db2sw/db2_v10_fp4_sb33045/lib64/libdb2e.so] ---- Signal 11 (SIGSEGV) delivered ---- _Z21sqliReadaheadPrefetchP7SQLI_CBP14SQLI_PAGE_DESCP28SQLI_READA HEAD_PREFETCH_INFO + 0x1e1 [/db2/db2iwt/db2sw/db2_v10_fp4_sb33045/lib64/libdb2e.so] _Z22sqliPerformPrefetchingP7SQLI_CBP16SQLI_PREFETCH_CBP14SQLI_PA GE_DESC + 0x660 [/db2/db2iwt/db2sw/db2_v10_fp4_sb33045/lib64/libdb2e.so] _Z8sqlischsP7SQLI_CBP10SQLD_ISTATP10SQLD_CSTATP10SQLD_TSTATP9sch s_datai + 0x4d0 [/db2/db2iwt/db2sw/db2_v10_fp4_sb33045/lib64/libdb2e.so] _Z8sqlistatP8sqeAgentP8SQLD_CCBjP9SQLD_IXCBP10SQLD_ISTATP10SQLD_ CSTATP10SQLD_TSTAT + 0x1580 [/db2/db2iwt/db2sw/db2_v10_fp4_sb33045/lib64/libdb2e.so] _Z14sqldIndexStatsP8sqeAgenttthtijP10SQLD_ISTATP10SQLD_TSTATPciS 5_ijRb + 0x890 [/db2/db2iwt/db2sw/db2_v10_fp4_sb33045/lib64/libdb2e.so] _Z17sqlrLocalRunstatsP8sqlrr_cbP11sqlrrstringS2_S2_httPP8sqlrg_p diiiiP16sqlrl_stats_colsPPsjPPtjdjdtPP20sqlr_runstats_resultS8_m mttjjlmP17sqlrlc_stats_infoPKhPKcm + 0x6ad0 [/db2/db2iwt/db2sw/db2_v10_fp4_sb33045/lib64/libdb2e.so] _Z8sqlrkstcP8sqlrr_cbP16sqlkdRqstRplyFmtiP15SQLR_RPCMESSAGE + 0x1570 [/db2/db2iwt/db2sw/db2_v10_fp4_sb33045/lib64/libdb2e.so] _Z16sqlrr_rpc_routerP8sqlrr_cb + 0xd50 [/db2/db2iwt/db2sw/db2_v10_fp4_sb33045/lib64/libdb2e.so] _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x1b50 [/db2/db2iwt/db2sw/db2_v10_fp4_sb33045/lib64/libdb2e.so] | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 10.1.0.5. * **************************************************************** | |
Local-Fix: | |
Avoid RUNSTATS command executing manually or automatically by DB2 auto maintenance with option INDEXSAMPLE. | |
Lösung | |
The problem is first fixed in DB2 version 10.1.0.5. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 30.01.2015 29.06.2016 29.06.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.5 |