home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 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
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 FixList