DB2 FOR LUW / DB2FORLUW / 970 - DB2

Starting with Version 9.7 Fix Pack 6, two new logical data 
groups of monitor elements have been added to statistics event 
monitors to support direct access to individual monitor elements 
that were previously returned only in XML documents. 
 
The logical data groups event_scmetrics and event_wlmetrics 
contain monitor elements that report metrics-related 
information.  These new logical data groups are missing the 
LAST_WLM_RESET element.  The LAST_WLM_RESET together with the 
STATISTICS_TIMESTAMP can be used to compute the size of the 
interval over which the metrics accumulated (ie. 
statistics_timestamp - last_wlm_reset = size_of_duration).

**************************************************************** 
* USERS AFFECTED:                                              * 
* Anyone using the statistics event monitor                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.7 Fix Pack 8.   Once the upgrade is     * 
* complete the scmetrics and wlmetrics tables of an existing   * 
* statistics event monitor can be altered to add the           * 
* last_wlm_reset column and then reorganized to make the       * 
* tables usable.    For example, if a statistics event monitor * 
* named "stat" was created in v9.7 Fix Pack 7 and uses an      * 
* scmetrics table named "scmetics_stat", the following         * 
* commands could be used:                                      * 
*                                                              * 
* db2 alter table scmetrics_stat add last_wlm_reset timestamp  * 
* not null with default                                        * 
* db2 reorg table scmetrics_stat                               * 
*                                                              * 
* Similarly, if that same event monitor uses a wlmetrics table * 
* named "wlmetics_stat", the following commands could be used: * 
*                                                              * 
* db2 alter table wlmetrics_stat add last_wlm_reset timestamp  * 
* not null with default                                        * 
* db2 reorg table wlmetrics_stat                               * 
*                                                              * 
* Note that the event monitor cannot be active when the target * 
* tables are altered.                                          * 
****************************************************************

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
 

Problem was first fixed in Version 9.7 Fix Pack 8

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

17.12.2012
01.04.2013
01.04.2013

9.7.FP7,
9.7.FP8