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 IC88630 Status: Geschlossen

SLOWER QUERY PLAN CAN BE MADE ON VARCHAR2 COMPABILITY DB IF EQUA LITY JOIN
PREDICATES ON CHAR OR GRAPHIC COLS WITH HOST VARIABLES

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
Databases that are created with Varchar2 Compability enabled 
may experience poorly performing query access plans for queries 
that have equality join predicates on CHAR or GRAPHIC columns 
and the same columns are used in an equal predicate with a 
VARCHAR or VARGRAPHIC host variable or parameter marker. 
 
  Your environment will need to be configured to use Deferred 
Prepare via the registry variable 
DB2_DEFERRED_PREPARE_SEMANTICS=YES or DB2_COMPATIBILITY_VECTOR 
to be impacted. 
 
  To verify is you are impacted by this problem, obtain the 
access plan and look for a FILTER operation above NLJOIN, MSJOIN 
or HSJOIN operation. For example 
 
0.178997 
 FILTER 
 (  25) 
 79.6035 
   NA 
   | 
 111.873 
 NLJOIN 
 (  26) 
 79.5749 
   NA 
 
  and where the operator details for the FILTER contains 
residual predicates referencing $Cx columns. For example: 
 
71) Residual Predicate, 
Comparison Operator: Equal (=) 
Subquery Input Required: No 
Filter Factor: 0.04 
 
Predicate Text: 
-------------- 
($C2 = $C1)
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Deferred Prepare user                                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2 Version 9.7 FixPack 8                         * 
****************************************************************
Local-Fix:
Turn off Deferred Prepare or explicitly cast the host 
variables / parameter markers to the type of the column used in 
the predicates.
verfügbare FixPacks:
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

Lösung
Problem was first fixed in Version 9.7 FixPack 8
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC91273 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
27.11.2012
08.04.2013
08.04.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP8
Problem behoben lt. FixList in der Version
9.7.0.8 FixList