|
Problem IC68267
|
Status: Geschlossen |
Control dynamic downward adjustment of FCM resources |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
Customers with large DPF environments like are experiencing
significant performance issues and
apparent hangs due to contention when FCM resources are tuned
automatically. The system
controller thread (db2sysc) will adjust FCM resources downward
after 30 minutes or more of low
workload. During relatively quiet times, the resources can get
adjusted down to very low values.
This causes problems on systems with large workload bursts. When
the workload increases dramatically,
the FCM resources need to be adjusted upwards quickly and this
is when performance issues due to latch
contention in the dynamic adjustment code occurs. This problem
gets worse on large DPF
instances with many logical partitions configured. |
| Problem-Zusammenfassung: |
Control dynamic downward adjustment of FCM resources |
| Local-Fix: |
Large DPF customers can set FCM resources to large fixed values.
However, the downside is that this may cause node failures in
cases when db2fcmr/db2fcms EDUs run out of FCM buffers/channels. |
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
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 |
Customers with large DPF environments like are experiencing
significant performance issues and
apparent hangs due to contention when FCM resources are tuned
automatically. The system
controller thread (db2sysc) will adjust FCM resources downward
after 30 minutes or more of low
workload. During relatively quiet times, the resources can get
adjusted down to very low values.
This causes problems on systems with large workload bursts. When
the workload increases dramatically,
the FCM resources need to be adjusted upwards quickly and this
is when performance issues due to latch
contention in the dynamic adjustment code occurs. This problem
gets worse on large DPF
instances with many logical partitions configured. |
| Workaround |
Upgrade to DB2 V9.7 FP3 |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 01.05.2010
01.11.2011
01.11.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
