DB2 FOR LUW / DB2FORLUW / 950 - DB2

Under rare scenarios, DB2 might abend under the following 
scenarios. 
1. The query has a nested OR predicate 
2. The deepest OR subterm has atleast one always false 
predicate. 
   Always false predicates are ones which can be found to be 
never true. eg. 1 = 0, col1 <> col1 (assuming col1 is not null), 
etc. 
3. The deep OR subterm has atleast one AND subterm. 
 
The following stack trace is observed: 
sqlnr_theorem_prover_detail 
sqlnr_prove_OR_tree 
sqlnr_theorem_prover 
sqlnr_qrwprep_phase2 
sqlnr_prep2_action 
sqlnr_comp 
sqlnr_seq 
sqlnr_rcc 
sqlnr_exe 
...

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to DB2 version 950 fixpack 10                 * 
****************************************************************

Rewrite the predicate to make the deep OR subterm be the last 
subterm in the topmost OR.

Problem is first fixed in DB2 version 950 fixpack 10

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

10.04.2012
30.10.2012
30.10.2012

9.5.0