|
Problem IC67458
|
Status: Geschlossen |
EXPLAIN SHOWS INCORRECT INDEX TABLESPACE WHEN INDEXES ARE IN A DIFFERENT TABLESPACE THAN THE TABLE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 980 - 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: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 9.8 FP3 or Subsequent Fix Pack *
**************************************************************** |
| Local-Fix: |
If need, look up the catalog to find the correct tablespace for
the indexes. |
| verfügbare FixPacks: |
DB2 Version 9.8 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux
|
| Lösung |
Problem First Fixed in DB2 Version 9.8 Fix Pack 3 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 25.03.2010
09.11.2012
09.11.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.8.FP3
|
| Problem behoben lt. FixList in der Version |
| 9.8.0.3
|
 |
