DB2 - Problembeschreibung
Problem IC83206 | Status: Geschlossen |
EXPLAIN OF FEDERATED QUERY INDICATES PREDICATE APPLIED TO WRONG OR NON-EXISTENT OPERATOR | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
A predicate may not show up in the explain output (db2exfmt, Visual Explain, Optimum Query Tuner), or it may be associated with the wrong operator, when a query against a remote table is explained, and that query includes a predicate against that remote table. You are experiencing this problem if the following query returns a non-zero count: select count(*) from explain_predicate where operator_id > (select max(operator_id) from explain_operator) You are also experiencing this problem if a local predicate is applied to an operator that does not contain the columns associated with that predicate. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All users of DB2 v10.1 who use the EXPLAIN facility * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade the DB2 Linux Unix and Windows server to v10.1 fix * * pack 1 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows | |
Lösung | |
This fix is in DB2 Linux Unix and Windows v10.1 fix pack 1. Upgrade to this version in order for the predicates to show as being applied at or below the SHIP operator and the Nickname Objects accessed by that SHIP operator. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 08.05.2012 02.11.2012 02.11.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.1 | |
10.5.0.1 |