|
Problem IC66998
|
Status: Geschlossen |
OTM fails with SQL20303N error when existing unique index no longer includes all partitioning keys on the target table |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
A unique index exists on a partitioned table, and then you
change the partitioning keys of the target table so that the
unique index definition no longer includes all the partitioning
keys, so OTM fails with the error SQL20303N when recreating this
unique index on the target table.
For example, you create a partitioned table which includes four
columns C1, C2, C3 and C4, specify the columns C1 and C2 as
partitioning keys, and create a unique index which includes the
columns C1 and C2. Then you change the partitioning keys of the
target table to the columns C2 and C3 so that existing unique
index definition doesn't include the partitioning key C3, so OTM
fails with the error SQL20303N when recreating this unique index
on the target table. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Users of ADMIN_MOVE_TABLE *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9,7 Fix Pack 2 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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 9a 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 10 for Linux, UNIX, and Windows
|
| Lösung |
Problem fixed in DB2 Version 9.7 Fix Pack 2 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC67059
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 09.03.2010
08.04.2010
08.04.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.0.7,
9.7.FP2
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.2
|
 |
