home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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 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
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList
9.7.0.5 FixList