|
Problem IT08849
|
Status: Geschlossen |
OPTIMIZER NOT WORKING CORRECTLY WHEN ONLY PART OF THE PARTITIONS HAVE DATA IN PARTITIONED TABLE. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
Optimizer not working correctly when only part of the partitions
have data in partitioned table.
[ENV]:
Operating system and level
Operating system is: AIX 64BIT 6.1.0.0
Server is running MPP/EEE (single node).
DB21085I This instance or install (instance name, where
applicable: "db2srmp")
uses "64" bits and DB2 code release "SQL09078" with level
identifier
"08090107".
Informational tokens are "DB2 v9.7.0.8", "s130316", "IP23426",
and Fix Pack
"8".
Optimizer not working correctly (Using TBSCAN not IXSCAN) when
only parts of the partitions have data in a partitioned table. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V9.7 fp11 or later. *
**************************************************************** |
| Local-Fix: |
As a work-around, customer can try removing the empty
partitions. |
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 11.05.2015
09.05.2017
09.05.2017 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP11
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.11
|
 |
