DB2 - Problem description
Problem IT31140 | Status: Closed |
CDE HSJN NOT PICKED UP FOR NON EQUAL PREDICATES(RANGE AND OR PREDICATES) | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
Db2 query may show poor performance for queries having CDE tables since HASH join is not picked up for joins having OR predicate or range predicate and there is no equality predicate. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * db2_main_prod * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.5 Mod 2 Fixpack 0 or higher * **************************************************************** | |
Local Fix: | |
Add dummy equality predicate to the query: nvl(mod(length(t1.col1),1),0) = nvl(mod(length(t2.col1),1),0) | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : follow-up : IT31145 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 03.12.2019 18.02.2020 18.02.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |