DB2 FOR LUW / DB2FORLUW / 970 - DB2

There is a component in DB2 compiler called Query ReWrite (QRW) 
which rewrites the customer queries 
to improve performance. 
 
One of the rewrites performed is removal of tautology 
predicates. 
Under rare scenarios, DB2 may trap with SIGSEGV (Signal #11) 
while trying to remove these predicates. 
 
Conditions for hitting the problem: 
1. The query involves one or more of tautology predicates 
2. The columns involved in the predicates in 1, are also part of 
generated column definition. 
 
 
The following stack trace will be reported in the trap file: 
 
5        sqlnr_remove_tautology_prd 
6        sqlnr_optprep 
7        sqlnr_optprep_action 
8        sqlnr_comp 
9        sqlnr_seq 
10       sqlnr_rcc 
11       sqlnr_exe 
12       sqlnn_cmpl 
13       sqlnn_cmpl

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

N/A

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
 

Problem is fixed in DB2 version 970 fixpack 6

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC84287 
Nachfolger : 

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

20.01.2012
06.06.2012
06.06.2012

9.7.0