IBM Support

IT29417: SNAPSHOT MONITOR TRAPPED IN FUNCTION SQLPLGETLOCKWAITINFO()

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
20 October 2019