|
Problem IC67458
|
Status: Closed |
EXPLAIN SHOWS INCORRECT INDEX TABLESPACE WHEN INDEXES ARE IN A DIFFERENT TABLESPACE THAN THE TABLE |
| product: |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 |
| 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. |
| Problem Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
Problem First Fixed in DB2 Version 9.8 Fix Pack 3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.03.2010
09.11.2012
09.11.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.8.FP3
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.8.0.3
|
 |
