|
Problem IC65811
|
Status: Geschlossen |
"SHOW EXPLAINED STATEMENTS HISTORY" FROM CC IS NOT LISTED. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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 |
| verfügbare FixPacks: |
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
|
| Lösung |
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 |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 25.01.2010
14.05.2010
14.05.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.1.,
9.1.FP6,
9.7.FP2
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.2
|
 |
