|
Problem IC90056
|
Status: Geschlossen |
DB2SUPPORT TOOL WHILE RUNNING IN OPTIMIZER MODE DOESN'T CLEANUP ALL EXPLAIN TABLES |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
when running db2support in optimizer mode like;
db2support . -d <db_name> -c -s -sf <input file> -cl 2 -o
pmr#.zip,
db2support creates explain tables using the userid as schema for
the explain tables. Once db2support is done collecting the
data from the explain, during the cleanup activity it drops the
newly created tables. However explain_actuals and object_metrics
are not dropped during this process.
" |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All users using DB2 V10.1 FP2 and below *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V10.1 FP3 *
**************************************************************** |
| Local-Fix: |
Manually drop the explain_actauls and object_metrics tables. |
| verfügbare FixPacks: |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Lösung |
First Fixed in Db2 V10.1 FP3 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 06.02.2013
29.10.2013
29.10.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
