|
Problem IC65199
|
Status: Closed |
DB2 CAN CRASH REMOVING DUPLICATE PREDICATES FROM THE OPTIMIZERS REWRITTEN QUERY |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problem description: |
DB2 may trap with SIGSEGV (Signal #11) in the sqlnr_optprep
function if the optimizers rewritten query has duplicate
predicates. When removing these duplicate predicates, we may
reference an already dereferenced piece of memory to cause the
segmentation fault.
The trap file produced will have the below stack:
__res_state
sqlnr_optprep
sqlnn_cmpl
sqlnn_cmpl
sqlra_compile_var
sqlra_find_var
sqlra_get_var
sqlrr_prepare |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of DB2 v9.1 *
****************************************************************
* PROBLEM DESCRIPTION: *
* DB2 may trap with SIGSEGV (Signal #11) in the sqlnr_optprep *
* *
* function if the optimizers rewritten query has duplicate *
* *
* predicates. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v9.1 FP9 or newer *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Solution |
|
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC65215
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.12.2009
19.04.2010
19.04.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.FP9
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.9
|
 |
