|
Problem IC65218
|
Status: Closed |
DB2 CAN CRASH REMOVING DUPLICATE PREDICATES FROM THE OPTIMIZERS REWRITTEN QUERY |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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 who run queries *
****************************************************************
* PROBLEM DESCRIPTION: *
* DB2 may trap with SIGSEGV (Signal #11) in the *
* sqlnr_optprepfunction if the optimizers rewritten query has *
* duplicatepredicates. When removing these duplicate *
* predicates, wemay reference an already dereferenced piece of *
* memory tocause the segmentation fault.The trap file produced *
* will have the below *
* stack:__res_statesqlnr_optprepsqlnn_cmplsqlnn_cmplsqlra_compil
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v9.7 FP2 or newer. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
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 9a 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 10 for Linux, UNIX, and Windows
|
| Solution |
Upgrade to DB2 v9.7 FP2 or newer. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IZ67166
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.12.2009
25.05.2010
25.05.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
