|
Problem IC69680
|
Status: Closed |
PERFORMANCE DEGRADATION AFTER THE UPGRADE TO DB2 V97 FROM EARLIER DB2 VERSIONS WHEN STMT_CONC IS ON. |
| product: |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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 |
| available fix packs: |
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux
|
| Solution |
Fixed in DB2 V98Fp4 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.07.2010
04.08.2011
04.08.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.8.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.8.0.4
|
 |
