Fixes are available
APAR status
Closed as program error.
Error description
When collecting monitoring data via the GET SNAPSHOT command, there is a small timing window that can cause Db2 server to trap. The following is a sample stack for this trap. <StackTrace> -----Frame------ ------Address----- ------Function + Offset------ 0x00001019E67EA6E0 0x000010000E305510 _Z20sqlplGetLockWaitInfoPK14sqeApplicationP9sqeBsuEduP8sqeAgentj PjP14sqlm_timestampP8SQLP_LRBP18sqlm_int_lock_waitPmS6_RK8sqlo_g mtb + 0x0690 ( = offset 0xDF95510 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00001019E67EA9F0 0x000010000C1936F8 _Z20sqm_write_lock_waitsP14sqeApplicationPK16sqm_agent_entityPK1 6sqeLocalDatabasejRK8sqlo_gmtP19sqm_snapshot_bufferPjP14sqlm_tim estampPmSC_SF_hP16sqlm_header_info + 0x04d8 ( = offset 0xBE236F8 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00001019E67EAE60 0x000010000C199110 ( = offset 0xBE29110 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00001019E67EAFE0 0x000010000C183CC4 ( = offset 0xBE13CC4 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00001019E67EB090 0x000010000C180AEC ( = offset 0xBE10AEC in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00001019E67EC340 0x000010000C176AE4 _Z12sqlmonssagntj13sqm_entity_idP6sqlmaijPvP14sqlm_collectedttP5 sqlca + 0x2cb4 ( = offset 0xBE06AE4 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00001019E67ED500 0x000010000C152318 _Z20sqlmPdbRequestRouterP8sqeAgent + 0x0a18 ( = offset 0xBDE2318 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00001019E67EDAB0 0x000010000B2AE040 ( = offset 0xAF3E040 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00001019E67EDD10 0x000010000B2A76F8 _Z21sqleProcessSubRequestP8sqeAgent + 0x22c8 ( = offset 0xAF376F8 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00001019E67EE120 0x000010000B328608 _ZN8sqeAgent6RunEDUEv + 0x09d8 ( = offset 0xAFB8608 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00001019E67EE2F0 0x000010001082FFBC _ZN9sqzEDUObj9EDUDriverEv + 0x025c ( = offset 0x104BFFBC in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00001019E67EE3B0 0x000010001082FD3C _Z10sqlzRunEDUPcj + 0x001c ( = offset 0x104BFD3C in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00001019E67EE3D0 0x000010000E2761E8 sqloEDUEntry + 0x09c8 ( = offset 0xDF061E8 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00001019E67EE790 0x0000100000088AF4 ( = offset 0x8AF4 in /lib64/libpthread.so.0) 0x00001019E67EEA10 0x0000100016CC8814 clone + 0x00e4 ( = offset 0x128814 in /lib64/libc.so.6) </StackTrace>
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * monitor a trapped * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * update to v11.1.4 fp5 * ****************************************************************
Problem conclusion
update to v11.1.4 fp5
Temporary fix
Comments
APAR Information
APAR number
IT29417
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
2019-06-12
Closed date
2019-10-20
Last modified date
2019-10-20
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 PSY
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:
03 May 2022