DB2 - Problem description
Problem IT38495 | Status: Closed |
DB2 MIGHT TERMINATE ABNORMALLY FOR QUERIES WITH MULTIPLE OUTER JOINS | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
If you have a a query that meets the following characteristics: 1. Query with multiple Outer join and equi-join predicates 2. Null producing side is a complex view 3. Where clause with equality predicates referencing the join columns and constants 4. Cost based it may trap in sqlnr_OJ_semi_join() with the following stack: sqlnr_OJ_semi_join sqlnr_qrwprep_phase2 sqlnr_prep2_action sqlnr_comp sqlnr_seq sqlnr_rcci sqlnr_exe This problem starts to happen on v11.1.4.6, doesn't happen on previous versions. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.1.4.7 * **************************************************************** | |
Local Fix: | |
Set the following registry - with the optimization guideline to the affected queries: /* */ or - at the instance level: db2set DB2COMPOPT=NOOJSJ -im | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.1.4.7 * **************************************************************** | |
Comment | |
Upgrade to 11.1.4.7 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.09.2021 17.04.2022 17.04.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |