|
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) |
