DB2 - Problem description
Problem IT34115 | Status: Closed |
Registry variable controls for query transformations involving scalar sub-queries and common table expressions | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
Certain query optimizer transformations involving scalar sub-queries and common table expressions could lead to poor performance. This APAR adds undocumented registry variable controls for these query transformations. These registry variables should only be used if recommended by Db2 support. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.5.5.0 or higher * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.5.5.0 or higher * **************************************************************** | |
Comment | |
Upgrade to Db2 11.5.5.0 or higher | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 03.09.2020 20.11.2020 20.11.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |