IBM Support

IT38665: SNAPSHOT MONITOR TRAPPED IN FUNCTION SQLPLGETLOCKWAITINFO()

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

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:                                              *
    * AIX/Linux                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade db2 to v11.5.4.0 and above                           *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IT38665

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B50

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-10-11

  • Closed date

    2021-10-12

  • Last modified date

    2021-10-12

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.5"}]

Document Information

Modified date:
13 October 2021