|
Problem IC65994
|
Status: Closed |
EXPLAIN SHOWS INCORRECT INDEX TABLESPACE WHEN INDEXES ARE IN A DIFFERENT TABLESPACE THAN THE TABLE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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: *
* 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. |
| available fix packs: |
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
|
| Solution |
Problem was first fixed in Version 9.7 Fix Pack 2. At a
minimum, this fix should be applied on the server side. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC67458
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.02.2010
23.04.2010
23.04.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
