DB2 - Problem description
Problem IT39274 | Status: Closed |
DB2 MIGHT PRODUCE A SQL0901N, EXECUTING QUERIES WITH UNION ALL | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
In rare scenarios, DB2 might produce a SQL0901N when the following is true at Optimized SQL: 1) The query contains one or more UNION ALL clauses 2) The query contains a DISTINCT or an existential subquery of the form IN/EXISTS Here is an example stack trace: ----- : sqlnn_erds destroy destroy sqlnq_union_ofn_sm sqlnq_union_ofn_sm sqlnq_viewsel_ofn_sm sqlnq_proc_enc add_doid sqlnq_sel_doid sqlnq_select_ofn_sm sqlnq_proc_enc sqlnq_union_ofn_sm sqlnq_viewsel_ofn_sm sqlnq_proc_enc add_doid sqlnr_addids sqlnr_joinppd_action : ----- | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to db2_v111m4fp6 or later * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to db2_v111m4fp6 or later * **************************************************************** | |
Comment | |
Upgrade to db2_v111m4fp6 or later | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 01.12.2021 01.12.2021 01.12.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |