DB2 - Problembeschreibung
Problem IC96677 | Status: Geschlossen |
SET INTEGRITY IMMEDIATE UNCHECKED FAILED WITH SQL20209N IF THE PARTITIONING KEY CONTAINS GENERATED COLUMN | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
create table t1 (i1 int not null, i2 int, i3 int, i4 int generated always as (i2+i3)) partition by range (i4) (starting 1 ending 100 ) DB20000I The SQL command completed successfully. set integrity for t1 off DB20000I The SQL command completed successfully. set integrity for t1 all immediate unchecked DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL20209N The "GENERATED COLUMN" option is not valid for table "TANJINXU.T1" with reason code "8". SQLSTATE=428FH | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users who issue SET INTEGRITY command or use * * ADMIN_MOVE_TABLE against range partitioning table with * * generated columns * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V10.1 Fix Pack 4 or higher * **************************************************************** | |
Local-Fix: | |
N/A | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 V10.1 Fix Pack 4 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 08.10.2013 02.06.2014 02.06.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.4 |