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

DB2LOOK MAY GENERATE THE SAME PREDICATE TO MIMIC STATISTICS FOR UNIQUE
INDEXES.

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
The db2look with -m option can generate the same predicates like 
as below against different indexes on the same table. 
 
WHERE COLNAMES = ' ' 
AND TABNAME = '<tabname>' AND TABSCHEMA = '<schema>'; 
 
COLNAMES is valid only if each column name is less than 30 bytes 
and if there are fewer than 16 columns in the index. Otherwise, 
the value can be blank. 
As the db2look uses COLNAMES to mimic index stats against 
primary key index and indexes for unique constraint. 
So db2look generates an invalid update statements to mimic index 
stats if a table has more than one indexes meet above 
conditions.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users who use db2look to mimic statistics for unique         * 
* indexes.                                                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to V10.5 FixPack 4 or later.                  * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Lösung
This problem was first fixed in DB2 V10.5 FixPack 4.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
23.10.2013
08.09.2014
08.09.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.4 FixList