|
Problem IC65218
|
Status: Geschlossen |
DB2 CAN CRASH REMOVING DUPLICATE PREDICATES FROM THE OPTIMIZERS REWRITTEN QUERY |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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: |
|
| verfügbare FixPacks: |
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
|
| Lösung |
Upgrade to DB2 v9.7 FP2 or newer. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IZ67166
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 18.12.2009
25.05.2010
25.05.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP2
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.2
|
 |
