IBM Support

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

Fixes are available

Db2 Version 11.1 Mod4 Fix Pack4 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 4 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            04 May 2022
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback