DB2 - Problembeschreibung
Problem IC68890 | Status: Geschlossen |
PERFORMANCE DEGRADATION AFTER THE UPGRADE TO DB2 V97 FROM EARLIER DB2 VERSIONS WHEN STMT_CONC IS ON. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
Performance degradation may be noticed after the upgrade to DB2 v97 from previous versions of DB2 using statement concentrator which is introduced in DB2 v97. During the performance degradation, package cache growth can be seen which may result into package cache overflow. To identify the issue, db2pd -apm dynamic can be collected for couple of iterations during the performance issue and you can see the number of variation inserts, the number of statement inserts/deletes into the package cache grows signifacantly. Also from traces collected, or from tprof output, you can see the following function being called and be the top user of CPU: sqlra_csm_del_stmt_empties This issue can only happen when stmt_conc database configuration parameter is set to LITERALS. | |
Problem-Zusammenfassung: | |
PERFORMANCE DEGRADATION AFTER THE UPGRADE TO DB2 V97 FROM EARLIER DB2 VERSIONS WHEN STMT_CONC IS ON. | |
Local-Fix: | |
Turn off the statement concentrator if not needed: db2 update db cfg for <db_name> using STMT_CONC OFF | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows | |
Lösung | |
Fixed in DB2 v97FP3 LOCAL FIX: Turn off the statement concentrator if not needed: db2 update db cfg for <db_name> using STMT_CONC OFF | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC69680 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 31.05.2010 29.09.2010 29.09.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP3 | |
Problem behoben lt. FixList in der Version | |
9.7.0.3 | |
9.7.0.3 |