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

DB2 MIGHT NOT CREATE IMPLIED PREDICATES ON GENERATED COLUMNS IN ORA
COMPATIBILITY MODE

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
Description: 
 
Under rare scenarios DB2 might not create implied predicates on 
generated columns leading to unoptimized access plans if the 
following conditions are true: 
1. The DB is created with DB2_COMPATIBILITY_VECTOR=ORA 
2. The query contains one or more partitioned tables 
3. The partitioned table is partitioned on one or more generated 
columns 
4. The generated expression contains mathematical operations 
such as DIV, MULT 
5. The columns referenced in the generated expression are used 
in a local predicate 
 
example: 
 
create table test_sales (a int, b int generated always as (a / 
5)) partition by range(b) (starting from (0) ending at (1000) 
every (50)); 
select * from test_sales where a > 500; 
An implied predicate: b> 100 can be generated for this scenario
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* First fixed in DB2 Version 10.1 Fix Pack 5 Recommendation:   * 
* Upgrade to DB2 Version 10.1 Fix Pack 5                       * 
****************************************************************
Local-Fix:
Lösung
See Problem Description above
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
12.09.2014
13.07.2015
13.07.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.5 FixList