|
Problem IC74063
|
Status: Closed |
INCORRECT STATEMENT INFORMATION REPORTED IN APPLICATION SNAPSHOT ACCOMPANIED BY INCREASING MONITOR HEAP CONSUMPTION AND SQL PERF |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
An application repeatedly executing a routine within the same
UOW may experience incorrect application snapshot information,
memory growth in monitor heap, and performance degradation. In
order for this problem to occur, the following conditions must
be satisfied:
- Statement monitoring is on
- The application calls a UDF or routine repeatedly within the
same UOW and the routine issues SQL statements
- The symptoms are likely to be more pronounced if MON_HEAP_SZ
is set to AUTOMATIC or a large fixed value
Application snapshots will contain increasing numbers of
repeated statement elements with the same package/section/cursor
information. Increasing growth of memory allocations from the
monitor heap may also be observed, and SQL statements executed
by the application may experience gradual performance
degradation. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users using DB2 V9.7 FP3a and below are affected. *
****************************************************************
* PROBLEM DESCRIPTION: *
* An application repeatedly executing a routine within the *
* same UOW may experience incorrect application snapshot *
* information, memory growth in monitor heap, and performance *
* degradation. *
****************************************************************
* RECOMMENDATION: *
* Please upgrade to DB2 V9.7 FP4 to avail a fix for this APAR. *
**************************************************************** |
| Local Fix: |
In some cases a temporary fix of configuring MON_HEAP_SZ to a
small fixed value has helped. |
| available fix packs: |
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
|
| Solution |
The issue is fixed in DB2 V9.7 FP4 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 24.01.2011
02.05.2011
02.05.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
