|
Problem IC90056
|
Status: Closed |
DB2SUPPORT TOOL WHILE RUNNING IN OPTIMIZER MODE DOESN'T CLEANUP ALL EXPLAIN TABLES |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
First Fixed in Db2 V10.1 FP3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 06.02.2013
29.10.2013
29.10.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
