|
Problem IC62577
|
Status: Geschlossen |
DB2LOOK DOES NOT GENERATE EVENT TABLE DDLS FOR NON WORKLOAD MANAGER EVENT MONITORS |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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. |
| verfügbare FixPacks: |
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
|
| Lösung |
Problem was first fixed in Version 9.7 Fixpack 1 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 17.08.2009
17.12.2009
07.01.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP1
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.1
|
 |
