|
Problem IC64843
|
Status: Geschlossen |
INSTANCE MAY ABEND COMPILING A QUERY IN EVALUATE INDEXES EXPLAIN MODE OR RUNNING DB2ADVIS FOR INDEX RECOMMENDATIONS (-M I) |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problembeschreibung: |
Compiling a query under EXPLAIN MODE EVALUATE INDEXES or running
the DB2 Design Advisor (db2advis) under index recommendation
mode, i.e., with the -m I command-line option, may cause the
instance to abend.
The conditions required for such an abend are:
- More than 1 predicate present in a query being evaluated
either under the EVALUATE INDEXES EXPLAIN MODE or as part of
the input workload for db2advis
- Index candidates in the ADVISE_INDEX table either (1) refer to
columns that are not part of the table for which they are
candidates or (2) refer to the same column more than once.
This can occur either by user error or if the table in
question was ALTERed. |
| Problem-Zusammenfassung: |
Compiling a query under EXPLAIN MODE EVALUATE INDEXES or running
the DB2 Design Advisor (db2advis) under index recommendation
mode, i.e., with the -m I command-line option, may cause the
instance to abend.
The conditions required for such an abend are:
- More than 1 predicate present in a query being evaluated
either under the EVALUATE INDEXES EXPLAIN MODE or as part of
the input workload for db2advis
- Index candidates in the ADVISE_INDEX table either (1) refer to
columns that are not part of the table for which they are
candidates or (2) refer to the same column more than once.
This can occur either by user error or if the table in
question was ALTERed. |
| Local-Fix: |
- Avoid ALTERing any tables during invocations of db2advis
- Ensure that any evaluation-candidate indexes populated into
the ADVISE_INDEX table are in valid form |
| verfügbare FixPacks: |
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Lösung |
Problem was first fixed in Version 9.1 Fix Pack 9. |
| Workaround |
- Avoid ALTERing any tables during invocations of db2advis
- Ensure that any evaluation-candidate indexes populated into
the ADVISE_INDEX table are in valid form |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 27.11.2009
13.04.2010
13.04.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.1.FP9
|
| Problem behoben lt. FixList in der Version |
| 9.1.0.9
|
 |
