DB2 - Problem description
Problem IC72604 | Status: Closed |
DB2 may abend when query has an OR predicate whose subterm predicates share common table(s) with join predicate(s) | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
DB2 database may abend if the following conditions are satisfied: 1. One query SELECT WHERE clause has join predicates (call jnPrds) as well as an OR predicate (called orPrd). 2. jnPrds involved a set of table, called JnPrdables. 3. orPrd is composed of two or more subterm predicates (orPrd1 OR orPrd2 OR .. OR orPrdN). Divide these subterm predicates into two groups: lOrPrd = (orPrd1 OR orPrd2 OR .. OR orPrdN-1) and rOrPrd = orPrdN. Now we know orPrd = (lOrPrd OR rOrPrd). 4. Call lOrPrd referenced table set as lOrPrdTables and rOrPrd referenced table set as rOrPrdTables. 5. lOrPrdTables and rOrPrdTables have exactly one intersect table. 6. One table from JnPrdables is contained in either lOrPrdTables or rOrPrdTables but not both of them. The trap file may contain various stack trace(s), e.g.: 1. Stack Trace: ... sqlnq_qunqncchild::pp sqlnq_qnc::local sqlnr_test_selectBT sqlnr_collapse_union_distinct_of_same_table sqlnr_qrwprep_phase1 sqlnr_prep1_action sqlnr_comp sqlnr_seq sqlnr_rcc sqlnr_exe sqlnn_cmpl sqlnn_cmpl sqlra_compile_var sqlra_find_var sqlra_get_var sqlrr_prepare sqljs_ddm_prpsqlstt sqljsParseRdbAccessed ... 2. Stack Trace: ... sqlnr_matchmaker::nav_assign_max_levels sqlnr_matchmaker::nav_assign_max_levels sqlnr_matchmaker::nav_assign_max_levels sqlnr_matchmaker::nav_assign_max_levels sqlnr_matchmaker::nav_init sqlnr_matchmaker::form_matches sqlnr_form_common_subexprs sqlnr_optprep sqlnr_optprep_action sqlnr_comp sqlnr_comp sqlnr_seq sqlnr_rcc sqlnr_exe ... | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Problem Description above. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 Fix Pack 4. * **************************************************************** | |
Local Fix: | |
db2set DB2COMPOPT=0,32768 Please recycle the instance after setting the above registry variable. | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows | |
Solution | |
First fixed in DB2 Version 9.7 Fix Pack 4. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 16.11.2010 01.05.2011 01.05.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP4 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.4 | |
9.7.0.5 |