|
Problem IC62577
|
Status: Closed |
DB2LOOK DOES NOT GENERATE EVENT TABLE DDLS FOR NON WORKLOAD MANAGER EVENT MONITORS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
The db2look does not generate event table DDLs, because db2look
added support for genrating CREATE EVENT MONITOR statements for
workload manager event monitors.
However, the new functionality also eliminates CREATE TABLE ddls
for event tables used by non workload manager event monitor.
The following steps illustrate one of the scenario on this
issue:
.
1. Create an event montior with WRITE TO TABLE option.
$ db2 create event monitor MYEVMON for connections write to
table
.
2. List the event tables for event monitor created step 1.
$ db2 list tables | grep MYEVMON
CONNHEADER_MYEVMON DB2INST1 T 2009-01-21-15.58.30.920910
CONNMEMUSE_MYEVMON DB2INST1 T 2009-01-21-15.58.31.899352
CONN_MYEVMON DB2INST1 T 2009-01-21-15.58.30.092150
CONTROL_MYEVMON DB2INST1 T 2009-01-21-15.58.31.443626
.
3. Run db2look to generate the event table DDL.
.
$ db2look -d sample -t CONN_MYEVMON -e
.
-- Table name specified is incorrect
.
This APAR will change the db2look to be able to generate event
table ddls for non workload manager event monitors. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users who use db2look to retrieve non-wlm event table DDLs. *
****************************************************************
* PROBLEM DESCRIPTION: *
* The db2look does not generate event table DDLs, because *
* db2look *
* added support for genrating CREATE EVENT MONITOR statements *
* for *
* workload manager event monitors. *
* *
* However, the new functionality also eliminates CREATE TABLE *
* ddls *
* for event tables used by non workload manager event monitor. *
****************************************************************
* RECOMMENDATION: *
* Users can retrieve table DDL after changing table name. *
**************************************************************** |
| Local Fix: |
Rename the table name befor users generate CREATE TABLE ddls for
non workload manager event monitors. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
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 9a 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 10 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in Version 9.7 Fixpack 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.08.2009
17.12.2009
07.01.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
