home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC77038 Status: Geschlossen

db2pd -latches output reports incorrect latch holder information.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* 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.                                          * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
The problem has been fixed for V97FP5 and will be done on upper 
releases as well.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
17.06.2011
08.12.2011
12.12.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP5
Problem behoben lt. FixList in der Version
9.7.0.5 FixList