IBM Support

IC77038: db2pd -latches output reports incorrect latch holder information.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • This error was occurring even when there really were holders
    traced by comparing the edu stack trace dump file, which showed
    edu was holding a latch, but db2pd -latch output says there were
    0 holders of that latch.
    
    $ db2pd -latch
    
    Database Member 0 -- Active -- Up 0 days 00:00:46 -- Date
    04/27/2011 13:12:18
    
    Latches:
    Address                     Holder     Waiter     Filename
      LOC    LatchType
    No latch holders.
    0x00002AAAB6333A24    0          26         sqle_agent.C  4246
     SQLO_LT_xmlcStringCache__LRULatch
    0x00002AAAB6333A2C   0          41         sqle_agent.C   4239
     SQLO_LT_xmlcStringCache__stringLatch
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All platforms affected.                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Starting with v95fp6, db2pd -latches has been returning      *
    * wrong results: holders were displayed as all 0's.            *
    * This error was occurring even when there really were holders *
    * traced by comparing the edu stack trace dump file, which     *
    * showed edu was holding a latch, but db2pd -latch output says *
    * there were 0 holders of that latch.                          *
    *                                                              *
    * $ db2pd -latch                                               *
    *                                                              *
    *                                                              *
    * Database Member 0 -- Active -- Up 0 days 00:00:46 -- Date    *
    *                                                              *
    * 04/27/2011 13:12:18                                          *
    *                                                              *
    * Latches:                                                     *
    *                                                              *
    * Address                         Holder    Waiter    Filename *
    * LOC     LatchType                                            *
    *                                                              *
    * No latch holders.                                            *
    *                                                              *
    * 0x00002AAAB6333A24     0          26        sqle_agent.C     *
    * 4246    SQLO_LT_xmlcStringCache__LRULatch                    *
    *                                                              *
    * 0x00002AAAB6333A2C     0          41        sqle_agent.C     *
    * 4239   SQLO_LT_xmlcStringCache__stringLatch                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Customer should upgrade to V97FP5 and upper                  *
    * releases/fix-packs.                                          *
    ****************************************************************
    

Problem conclusion

  • The problem has been fixed for V97FP5 and will be done on upper
    releases as well.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC77038

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-06-17

  • Closed date

    2011-12-08

  • Last modified date

    2011-12-12

  • 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

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC77038

Modified date: 12 December 2011