DB2 - Problembeschreibung
Problem IC96007 | Status: Geschlossen |
SYSTEM APPLICATIONS INVOLVED IN A LOCKING EVENT ONLY SHOW UP AS PARTIAL EVENTS. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
When a system application that makes use of the catalog scan interface is involved in a locking event (deadlock, lock wait or lock timeout), the locking event will only be processed as a "partial event". This is due to an issue with the current activity that is setup - the participant_no used for them is zero rather than the correct value. This results in a mismatch in participant numbers when evmon_format_ue_to_xml is determining if an event is complete. This means the customer won't be able to properly debug locking events involving system applications. This includes db2lused and db2reorg. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Anybody using the LOCKING event monitor. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Version 9.7 Fix Pack 9. Also, drop the * * registered XML schema object associated with the tables * * produced by EVMON_FORMAT_UE_TO_TABLES for the locking event * * monitor by using the following command: DROP XSROBJECT * * EVMON_LOCKING_SCHEMA_SQL09070. This schema object will be * * reregistered the next time EVMON_FORMAT_UE_TO_TABLES is run * * against the locking event monitor. * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in Version 9.7 Fix Pack 9 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC96030 IC96031 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 17.09.2013 16.12.2013 16.12.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP9 | |
Problem behoben lt. FixList in der Version | |
9.7.0.9 | |
9.7.0.9 |