DB2 FOR LUW / DB2FORLUW / 970 - DB2

The db2look tool will extract the 'create event monitor' DDL for 
WLM event monitors, but will not display the 'create table' DDL 
for the underlying event monitor tables. The 'create event 
monitor' DDL alone, however, will not be sufficient for the user 
to recreate the same event monitors elsewhere, as the underlying 
tables may have been altered or customized by the user (which 
is, as supported, use case for event monitors). In order to 
fully reproduce the event monitors the user requires both the 
'create event monitor' DDL, as well as the 'create table' DDL. 
To address this scenario we have removed the restriction that 
prevents db2look from displaying the 'create table' DDL for WLM 
event monitor tables.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.7 Fix pack 5.                           * 
****************************************************************

N/A

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
 

First fixed in Version 9.7 Fix Pack 5.

not known / see Local fix

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

05.05.2011
19.12.2011
19.12.2011

9.7.FP5