IT25560: Statistics event monitor traps when event monitor generation overlaps activation of the statistics event monitor.

APAR status

• Closed as program error.

Error 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:
  
  <StackTrace>
  -----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)
  </StackTrace>
  

Local fix

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

Problem conclusion

• First Fixed in DB2 Version V11.1 modpack 4 fixpack 4
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP