DB2 FOR LUW / DB2FORLUW / A10 - DB2

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

**************************************************************** 
* 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                    * 
****************************************************************

N/A

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

First fixed in DB2 V10.1 Fix Pack 4

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

08.10.2013
02.06.2014
02.06.2014