DB2 - Problem description
Problem IC69541 | Status: Closed |
MON_CURRENT_SQL CAN RETURN INCORRECT METRICS WHEN MULTIPLE STATEMENTS OPEN CONCURRENTLY. | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
The metrics in MON_CURRENT_SQL summary view (WLM_METRICS summary table) are aggregated only by app handle. If an application has multiple statements open concurrently (e.g. multiple cursors) the metrics reported for each cursor will be the sum across all activities (all cursors in this example). | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All platform * **************************************************************** * PROBLEM DESCRIPTION: * * The metrics in MON_CURRENT_SQL summary view can be wrong if * * the application contain multiple statements. For example, a * * application have multiple cursors open concurrently. * **************************************************************** * RECOMMENDATION: * * Update to V9.7 FP3. * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows | |
Solution | |
DB2 V9.7 FP3 will contain the fix. | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC69631 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 29.06.2010 23.09.2010 23.09.2010 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP3 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.3 | |
9.7.0.3 |