DB2 - Problembeschreibung
Problem IC65994 | Status: Geschlossen |
EXPLAIN SHOWS INCORRECT INDEX TABLESPACE WHEN INDEXES ARE IN A DIFFERENT TABLESPACE THAN THE TABLE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
When XML indexes are in a different tablespace than the table, explain shows the table tablespace for the XML indexes. For other types of indexes, the problem exist only when the statement is explained using section information via EXPLAIN_FROM_ACTIVITY, EXPLAIN_FROM_CATALOG, EXPLAIN_FROM_DATA, or EXPLAIN_FROM_SECTION procedures. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * When XML indexes are in a different tablespace than the * * table, * * explain shows the table tablespace for the XML indexes. * * * * For other types of indexes, the problem exist only when the * * * * statement is explained using section information via * * * * EXPLAIN_FROM_ACTIVITY, EXPLAIN_FROM_CATALOG, * * EXPLAIN_FROM_DATA, * * or EXPLAIN_FROM_SECTION procedures. * **************************************************************** * RECOMMENDATION: * * Apply the service pack. * **************************************************************** | |
Local-Fix: | |
If need, look up the catalog to find the correct tablespace for the indexes. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in Version 9.7 Fix Pack 2. At a minimum, this fix should be applied on the server side. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC67458 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 02.02.2010 23.04.2010 23.04.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP2 | |
Problem behoben lt. FixList in der Version | |
9.7.0.2 |