IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    IT25560

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-07-02

  • Closed date

    2019-01-22

  • Last modified date

    2019-01-22

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
22 January 2019