DB2 - Problembeschreibung
Problem IC65597 | Status: Geschlossen |
POSSIBLE PERFORMANCE ISSUE RELATED TO TABLE QUEUE PERFORMANCE AND TABLE QUEUE SPILLING | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
In a DPF environment, and/or if INTRA_PARALLEL dbm cfg parameter is turned on, queries may involve multiple db2 agents to execute them. Sometimes, rows need to be sent and received on table queues, the mechanism for flowing rows between agents via FCM functionality. The logic for sending and receiving involves a flow control mechanism for regulating the flow of rows between senders and receivers. Part of this logic uses in internal timing delay which gets calculated dynamically. This fix will ensure the timing delay calculations are more accurate, which may improve performance with respect to table queues and table queue spilling. If snapshots are showing a lot of table queue spilling, this APAR might help reduce table queue spilling, depending on the situation. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * DPF and/or SMP * **************************************************************** * PROBLEM DESCRIPTION: * * POSSIBLE PERFORMANCE ISSUE RELATED TO TABLE QUEUE * * PERFORMANCE AND TABLE QUEUE SPILLING. * **************************************************************** * RECOMMENDATION: * * Upgrade to db2 v9.1 FP8 * **************************************************************** | |
Local-Fix: | |
non | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in v9.1 FP8. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 15.01.2010 12.07.2010 12.07.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.1.FP8 | |
Problem behoben lt. FixList in der Version | |
9.7.0.2 |