DB2 - Problem description
Problem IC77065 | Status: Closed |
FIX DB2PD -LATCHES OUTPUT | |
product: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problem 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 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All platforms are affected. * **************************************************************** * PROBLEM 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. * * * * Example: * * * * $ 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 V95FP9 and upper * * releases/fixpacks. * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows | |
Solution | |
Problem has been fixed for V95FP9 and will be done on upper releases as well. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 20.06.2011 12.03.2012 12.03.2012 |
Problem solved at the following versions (IBM BugInfos) | |
9.5.FP9 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.5.0.9 |