IT29417: SNAPSHOT MONITOR TRAPPED IN FUNCTION SQLPLGETLOCKWAITINFO()

Db2 Version 11.1 Mod 4 Fix Pack 5 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 6 for Linux, UNIX, and Windows

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