|
Problem IC65811
|
Status: Closed |
"SHOW EXPLAINED STATEMENTS HISTORY" FROM CC IS NOT LISTED. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
After migrating to V9.1 Fix Pack 6 the option "Show Explained
Statement History" in the Control Center does not list the
access plans that was created in V8.
If an access plan is created in the V9.1, the data is returned
in the option, but not those that was created in V8.
The explain tables are populated (EXPLAIN_INSTANCE and
EXPLAIN_STATEMENT). |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users using DB2 9.7 *
****************************************************************
* PROBLEM DESCRIPTION: *
* "SHOW EXPLAINED STATEMENTS HISTORY" FROM CC IS NOT LISTED. *
****************************************************************
* RECOMMENDATION: *
* Apply DB2 V9.7 FP2 *
**************************************************************** |
| Local Fix: |
n/a |
| available fix packs: |
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 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a 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 |
After migrating to V9.1 Fix Pack 6 the option "Show Explained
Statement History" in the Control Center does not list the
access plans that was created in V8.
If an access plan is created in the V9.1, the data is returned
in the option, but not those that was created in V8.
The explain tables are populated (EXPLAIN_INSTANCE and
EXPLAIN_STATEMENT). |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.01.2010
14.05.2010
14.05.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.,
9.1.FP6,
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
