DB2 - Problem description
Problem IT28596 | Status: Closed |
QUERY WITH INDEX SCAN ON A COLUMNAR TABLE WHICH IS UNDER A UNIONMAY GET INCORRECT RESULT | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
If Query has a Plan where UNION has a leg with Index Scan on a Columnar Table, then it is possible to get incorrect result. Example problem portion of the Plan: UNION | /-------+------- TBSCAN FETCH from /----+----- Table A IXSCAN CO-TABLE: Table B | INDEX: Index_Table_B | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * COLUMNAR TABLES WITH INDEXES ONLY * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Please, See Error Description and Install this Fix. * **************************************************************** | |
Local Fix: | |
db2set DB2_REDUCED_OPTIMIZATION="COL_IXSCAN_ALL_V1133 OFF" -im option can be used, BUT Static sql will need to be reboud and already compiled dynamic sql re-compiled as well. | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.03.2019 29.11.2019 29.11.2019 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |