|
Problem IC82462
|
Status: Closed |
Regression v95fp9 - Performance degradation when reading registry variables under heavy workloads. |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
when a DB2 process tries to read the registry variables on a
very busy system the performance degradation might occur. Its
due to the retry mechanism added to handle the timing related
issue in another code path, which increased the number of calls
to certain DB2 functions. The increase in number of calls to
those functions added up more execution time, resulted in
performance degradation. So the performance impact could be
present in any workload you run in v95fp9, which probably is
negligible for most of the typical workloads and can be
noticeable on a busy system. Calling db2set frequently under a
heavy workload will increase the possibility of hitting this
issue. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 Server installed systems. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrading to DB2 version v95fp10 resolves this issue. *
**************************************************************** |
| Local Fix: |
Reduce the calls to db2set, especially if its run too frequently
to update the registry variables. |
| Solution |
This problem is first fixed in v95fp10. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.04.2012
22.08.2012
22.08.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.10
|
 |
