DB2 - Problembeschreibung
Problem IT04161 | Status: Geschlossen |
DB2 MIGHT ABEND WHEN EXECUTING QUERY CONTAINING A SUBSELECT WITH REDUNDANT PREDICATES | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
Under rare scenarios, DB2 might abend if the following conditions are true: 1) The query contains one or more subqueries. The subquery can be of the form EXISTS, NOT EXISTS, etc. 2) The subquery contains one or more correlated predicates 3) Atleast one of the correlated predicate in the subquery can be proven to be redundant due to a check constraint, tautology predicates, etc. 4) The subquery and the correlated column reference the same view or common table expression. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 970 fixpack 10 * **************************************************************** | |
Local-Fix: | |
Remove the redundant predicate | |
Lösung | |
Problem is fixed in DB2 version 970 fixpack 10 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 03.09.2014 29.01.2015 29.01.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.0 | |
Problem behoben lt. FixList in der Version | |
9.7.0.10 |