|
Problem IT01540
|
Status: Closed |
SET INTEGRITY IMMEDIATE UNCHECKED FAILED WITH SQL20209N IF THE PARTITIONING KEY CONTAINS GENERATED COLUMN |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 10.5fp4 *
**************************************************************** |
| Local Fix: |
N/A |
| available fix packs: |
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
|
| Solution |
Upgrade to DB2 version 10.5 fix pack 4 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 05.05.2014
08.09.2014
08.09.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.4
|
 |
