home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
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
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 FixList
10.5.0.1 FixList