|
Problem IT08849
|
Status: Closed |
OPTIMIZER NOT WORKING CORRECTLY WHEN ONLY PART OF THE PARTITIONS HAVE DATA IN PARTITIONED TABLE. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 11.05.2015
09.05.2017
09.05.2017 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP11
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.11
|
 |
