|
Problem IT06862
|
Status: Closed |
DB2 might trap while collecting statistics for indexes |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| Solution |
The problem is first fixed in DB2 version 10.1.0.5. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 30.01.2015
29.06.2016
29.06.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.5
|
 |
