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

INDEX CORRUPTION RESULTING FROM OPERATIONS ON DETACHED PARTITIONS FROM
TABLE WITH PARTITIONED INDEXES

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
There are two problems here: 
 
1) This problem results in an empty index being created on the 
detach partition, despite the partition not being empty.  To hit 
this problem you need to detach a partition that has partitioned 
index(es) that require rebuilding.  If the asynchronous 
partition detach task does not fully complete and a crash occurs 
and then restart database is then executed and the database is 
configured to have indexes rebuilt on restart (controlled by the 
indexrec Database and Database Manager configuration 
parameters), it will then rebuild the problem indexes on each 
partition, but on the partially detached partition (still in the 
logically detached state), the index will be created empty. 
Later, once the database has been restarted the asynchronous 
partitioned detach task will complete the detach and the 
standalone table may have data with an empty index. 
 
2) This problem can result in an index on a non-partitioned 
table to be marked as unique in the catalogs but not in the 
actual index object (or the reverse, non-unique in the catalogs 
but unique in the actual index).  As a result it does not 
enforce uniqueness correctly.  The following is an example of 
how this can occur: 
- partitioned table with a non-unique partitioned index on not 
nullable columns where the index key columns are a super-set of 
the table partitioning key columns 
- a partition is detached and before the asynchronous portion of 
the partition detach completes 
- the table is altered to add a primary or unique key using the 
same columns, in the same order, as the partitioned index 
mentioned above (i.e. we will convert the existing index from 
non-unique to unique).  If at this point you dropped a primary 
or unique constraint, you may see experience the reverse of this 
issue (non-unique in the catalogs but unique in the actual 
index) provide that the index existed prior to the primary key 
or unique constraint being added to the table. 
- the asynchronous partitioned detach task completes and the 
detached partition is now a fully accessible standalone 
non-partitioned table where the catalogs and index object are 
inconsistent
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7.0.6.                              * 
****************************************************************
Local-Fix:
Recreate the affected indexes.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
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
The problem was first fixed in DB2 version 9.7.0.6.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
29.03.2012
05.06.2012
05.06.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.0.6
Problem behoben lt. FixList in der Version
9.7.0.6 FixList