|
Problem IC72602
|
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 / 950 - 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 ERROR DESCRIPTION *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.5 Fix Pack 8. *
**************************************************************** |
| Local Fix: |
db2set DB2COMPOPT=0,32768
Please recycle the instance after setting the above registry
variable. |
| available fix packs: |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 Version 9.5 Fix Pack 8. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC72604 IC72605
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.11.2010
01.07.2011
01.07.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.8
|
 |
