|
Problem IC80931
|
Status: Closed |
DB2 INSTANCE MAY CRASH WHEN REMOVING TAUTOLOGY PREDICATES DURING QUERY REWRITE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Please upgrade to DB2 version 970 fixpack 6 *
**************************************************************** |
| Local Fix: |
N/A |
| available fix packs: |
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
|
| Solution |
Problem is fixed in DB2 version 970 fixpack 6 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC84287
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 20.01.2012
06.06.2012
06.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.0
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
