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

RUNNING DB2ADVIS TO RECOMMEND DPF PARTITIONS CAN CAUSE DB2 INSTANCE TO TRAP

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
Running db2advis to recommend DPF partitions can cause DB2 
instance to trap if the SQL statements that are passed into 
db2advis meet all of the following conditions: 
 
1) A table is NULL-producing side of an outer join 
2) At least one of the partitioning columns of the table is 
bound to a constant, or is bound to a column in the outer SQL 
block (i.e. outer reference), via an equality predicate, or via 
transitivity of multiple equality predicates. 
 
A similar trap stack will look like the folllowing: 
 
sqlno_part_scale_index 
sqlno_cost_ridbid_iscan 
sqlno_cost_iscan 
sqlno_prop_iscan 
sqlno_index_scan 
sqlno_crule_index_scan 
sqlno_crule_access_root 
sqlno_crule_access 
sqlno_plan_qun
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DPF                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 7                        * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
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

Lösung
Problem was first fixed in DB2 Version 9.7 Fix Pack 7
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
16.07.2012
31.10.2012
31.10.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP7
Problem behoben lt. FixList in der Version
9.7.0.7 FixList