invispix 10x10
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT39306 Status: Closed

THE OPTIMIZER MIGHT FAVOUR A NON-OPTIMAL PLAN WITH REGISTRY VARIABLE
DB2_EXTENDED_OPTIMIZATION=NLJN_OFLOW

product:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problem description:
When the registry variable DB2_EXTENDED_OPTIMIZATION=NLJN_OFLOW
is set, the optimizer might favour a sub-optimal NLJOIN when the
table accessed on the inner has overflow records.
The inner of the NLJOIN will consist of either an index
oring(IXOR), index anding(IXAND), or list prefetch (LPREFETCH)
access plan.
The NLJOIN choice is more likely to be non-optimal when all, or
most of the rows in the inner qualify the join.
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to 11.1.4.7                                          *
****************************************************************
Local Fix:
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       :
03.12.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)
invispix 10x10
invispix 10x10
Versions InfomailVersions Infomail

Versions Infomail

Product LifecycleProduct Lifecycle

Lifecycle

Current BugsCurrent Bugs

Current Bugs

Bug ResearchBug Research

Bug Research

Bug FixlistsBug Fixlists

Bug Fixlists

invispix 10x10