|
Problem IC84287
|
Status: Geschlossen |
DB2 INSTANCE MAY CRASH WHEN REMOVING TAUTOLOGY PREDICATES DURING QUERY REWRITE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
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 |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Please upgrade to DB2 version 10.1 fixpack 1 *
**************************************************************** |
| Local-Fix: |
N/A |
| verfügbare FixPacks: |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Lösung |
Problem has been fixed in DB2 Version 10.1 fixpack 1 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 13.06.2012
01.11.2012
01.11.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
