|
Problem IC69680
|
Status: Geschlossen |
PERFORMANCE DEGRADATION AFTER THE UPGRADE TO DB2 V97 FROM EARLIER DB2 VERSIONS WHEN STMT_CONC IS ON. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 980 - 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: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* PERFORMANCE DEGRADATION AFTER THE UPGRADE TO DB2 V97 FROM *
* EARLIER DB2 VERSIONS WHEN STMT_CONC IS ON. *
****************************************************************
* RECOMMENDATION: *
* Turn off the statement concentrator if not needed: *
* *
* *
* *
* db2 update db cfg for <db_name> using STMT_CONC OFF *
* *
* or *
* *
* upgrade to DB2 V98 Fp4 *
**************************************************************** |
| 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.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux
|
| Lösung |
Fixed in DB2 V98Fp4 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 08.07.2010
04.08.2011
04.08.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.8.FP4
|
| Problem behoben lt. FixList in der Version |
| 9.8.0.4
|
 |
