suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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)