DB2 - Problem description
Problem IT25560 | Status: Closed |
Statistics event monitor traps when event monitor generation overlaps activation of the statistics event monitor. | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
Statistic event monitor might crash when statistics event monitor event generation overlaps with activation of the statistics event monitor. The stack will show the following functions: -----FUNC-ADDR---- ------FUNCTION + OFFSET------ 0x00007FE91E3197A6 _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm + 0x0356 (/db2home/db2edwp1/sqllib/lib64/libdb2osse.so.1) 0x00007FE91E3193EB ossDumpStackTraceV98 + 0x002b (/db2home/db2edwp1/sqllib/lib64/libdb2osse.so.1) 0x00007FE91E315597 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00d7 (/db2home/db2edwp1/sqllib/lib64/libdb2osse.so.1) 0x00007FE9254EC807 sqlo_trce + 0x03c7 (/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1) 0x00007FE9256538C1 sqloEDUCodeTrapHandler + 0x03b1 (/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1) 0x000000367140F7E0 address: 0x000000367140F7E0 ; dladdress: 0x0000003671400000 ; offset in lib: 0x000000000000F7E0 ; (/lib64/libpthread.so.0) 0x0000000000422BA0 __intel_avx_rep_memcpy + 0x0270 (db2sysc 66) 0x00007FE9241B2642 _ZN16sqmMetricsPacker18PackRequestMetricsEPK17sqmRequestMetricsP ciPt + 0x0062 (/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1) 0x00007FE925DE154B _ZN18sqlrwWorkloadStats15collectAndResetEP8sqeAgentP23sqlrwEvmon MetricsParamsPciiP8sqlo_gmtP16sqeLocalDatabasel + 0x118b (/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1) 0x00007FE925DDEF5C _Z30sqlrwLocalCollectAndResetStatsP8sqlrr_cbP8sqlo_gmtl + 0x042c (/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1) 0x00007FE925DFD474 _Z17sqlrwWlmRPCRouterP8sqlrr_cbP23SQLKD_RQST_REPLY_FORMATiPP15SQ LR_RPCMESSAGEPb + 0x0c44 (/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1) 0x00007FE925CB9896 _Z16sqlrr_rpc_routerP8sqlrr_cb + 0x0f36 (/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1) 0x00007FE925CB766F _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x103f (/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1) 0x00007FE92384B6DF address: 0x00007FE92384B6DF ; dladdress: 0x00007FE91E86C000 ; offset in lib: 0x0000000004FDF6DF ; (/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1) 0x00007FE923849FB0 _Z21sqleProcessSubRequestP8sqeAgent + 0x03e0 (/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1) 0x00007FE92387E537 _ZN8sqeAgent6RunEDUEv + 0x05d7 (/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1) 0x00007FE9270983E6 _ZN9sqzEDUObj9EDUDriverEv + 0x0116 (/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1) 0x00007FE925650808 sqloEDUEntry + 0x0578 (/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1) 0x0000003671407AA1 address: 0x0000003671407AA1 ; dladdress: 0x0000003671400000 ; offset in lib: 0x0000000000007AA1 ; (/lib64/libpthread.so.0) 0x0000003670CE8BCD clone + 0x006d (/lib64/libc.so.6) | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Any db2 user * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * To avoid experiencing this issue users can move to DB2 * * Version V11.1 modpack 4 fixpack 4 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 02.07.2018 22.01.2019 22.01.2019 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |