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