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