DB2 - Problembeschreibung
Problem IC80198 | Status: Geschlossen |
System controller EDU (DB2SYSC) held up due to contention for th e FCM dynamic update latch causes apparent performance slowdown. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 | |
Problembeschreibung: | |
Multiple logical nodes on the same machine share the same FCM resource pools. The system controller EDU (db2sysc) on each logical node wakes up periodically to determine if FCM resource tuning is necessary. The system controller EDUs contend for the FCM dynamic update latch(m_dynUpdateLatch) in order to perform the tuning. The remaining system controller EDUs and agent EDUs can end up waiting for the latch until tuning completes and the latch is released. This can lead to performance slowdowns. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * DPF, MPP * **************************************************************** * PROBLEM DESCRIPTION: * * Multiple logical nodes on the same machine share the same * * FCM resource pools. The system controller EDU (db2sysc) on * * each logical node wakes up periodically to determine if FCM * * resource tuning is necessary. The system controller EDUs * * contend for the FCM dynamic update latch(m_dynUpdateLatch) * * in order to perform the tuning. The remaining system * * controller EDUs and agent EDUs can end up waiting for the * * latch until tuning completes and the latch is released. This * * can lead to performance slowdowns. * **************************************************************** * RECOMMENDATION: * * Update to version 9.1 fixpack 12 or later fixpacks. * **************************************************************** | |
Local-Fix: | |
Lösung | |
This problem is first fixed in version 9.1 fixpack 12. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 05.12.2011 17.07.2012 17.07.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.1.FP12 | |
Problem behoben lt. FixList in der Version |