DB2 FOR LUW / DB2FORLUW / A10 - DB2

Given a table whose DDL defines a table with a generated column 
referenced by a MDC key, doing ADMIN_MOVE_TABLE will result in 
SQL20209N. admin_move_table calls "set integrity on XXXX all 
immediate unchecked" of which "immediate unchecked" can't be 
used on a table with a generated column. 
 
Example of errors from CLP in FP2: 
 
db2 "call 
ADMIN_MOVE_TABLE('T996463','TEQUIPMENT','USERSPACE1','USERSPACE1 
','USERSPACE1','',NULL,'',NULL,'COPY_USE_LOAD \"COPY YES TO 
/home/denisyhw/pmr/51349/temp\",NO_STATS,NO_AUTO_REVAL,NON_CLUST 
ER','MOVE')" 
SQL2104N  The ADMIN_MOVE_TABLE procedure could not be completed 
at this time 
by this user.  Reason code: "4".  SQLSTATE=5UA0M 
db2 "call 
ADMIN_MOVE_TABLE('T996463','TDETECTOR_SITE','USERSPACE1','USERSP 
ACE1','USERSPACE1','',NULL,'',NULL,'COPY_USE_LOAD \"COPY YES TO 
/home/denisyhw/pmr/51349/temp\",NO_STATS,NO_AUTO_REVAL,NON_CLUST 
ER','MOVE')" 
SQL2104N  The ADMIN_MOVE_TABLE procedure could not be completed 
at this time 
by this user.  Reason code: "4".  SQLSTATE=5UA0M 
db2 "call 
ADMIN_MOVE_TABLE('T996463','TREADING2','USERSPACE1','USERSPACE1' 
,'USERSPACE1','',NULL,'',NULL,'COPY_USE_LOAD \"COPY YES TO 
/home/denisyhw/pmr/51349/temp\",NO_STATS,NO_AUTO_REVAL,NON_CLUST 
ER','MOVE')" 
SQL2104N  The ADMIN_MOVE_TABLE procedure could not be completed 
at this time 
by this user.  Reason code: "4".  SQLSTATE=5UA0M 
db2 "call 
ADMIN_MOVE_TABLE('T996463','TTRAIN','USERSPACE1','USERSPACE1','U 
SERSPACE1','',NULL,'',NULL,'COPY_USE_LOAD \"COPY YES TO 
/home/denisyhw/pmr/51349/temp\",NO_STATS,NO_AUTO_REVAL,NON_CLUST 
ER','MOVE')" 
SQL2104N  The ADMIN_MOVE_TABLE procedure could not be completed 
at this time 
by this user.  Reason code: "4".  SQLSTATE=5UA0M 
 
Example of errors that appear for FP3: 
db2 "call 
ADMIN_MOVE_TABLE('T996463','TEQUIPMENT','USERSPACE1','USERSPACE1 
','USERSPACE1','',NULL,'',NULL,'COPY_USE_LOAD \"COPY YES TO 
/home/denisyhw/pmr/51349/temp\",NO_STATS,NO_AUTO_REVAL,NON_CLUST 
ER','MOVE')" 
SQL20209N  The "GENERATED COLUMN" option is not valid for table 
"T996463.TREADING2" with reason code "8".  SQLSTATE=428FH 
db2 "call 
ADMIN_MOVE_TABLE('T996463','TDETECTOR_SITE','USERSPACE1','USERSP 
ACE1','USERSPACE1','',NULL,'',NULL,'COPY_USE_LOAD \"COPY YES TO 
/home/denisyhw/pmr/51349/temp\",NO_STATS,NO_AUTO_REVAL,NON_CLUST 
ER','MOVE')" 
SQL20209N  The "GENERATED COLUMN" option is not valid for table 
"T996463.TREADING2" with reason code "8".  SQLSTATE=428FH 
db2 "call 
ADMIN_MOVE_TABLE('T996463','TREADING2','USERSPACE1','USERSPACE1' 
,'USERSPACE1','',NULL,'',NULL,'COPY_USE_LOAD \"COPY YES TO 
/home/denisyhw/pmr/51349/temp\",NO_STATS,NO_AUTO_REVAL,NON_CLUST 
ER','MOVE')" 
SQL0270N  Function not supported (Reason code = "52"). 
SQLSTATE=42997 
db2 "call 
ADMIN_MOVE_TABLE('T996463','TTRAIN','USERSPACE1','USERSPACE1','U 
SERSPACE1','',NULL,'',NULL,'COPY_USE_LOAD \"COPY YES TO 
/home/denisyhw/pmr/51349/temp\",NO_STATS,NO_AUTO_REVAL,NON_CLUST 
ER','MOVE')" 
SQL0668N  Operation not allowed for reason code "10" on table 
"T996463.TREADING2".  SQLSTATE=57016

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2LUW                                                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Given a table whose DDL defines a table with a generated     * 
* column                                                       * 
* referenced by a MDC key, doing ADMIN_MOVE_TABLE will result  * 
* in                                                           * 
* SQL20209N. admin_move_table calls "set integrity on XXXX all * 
* immediate unchecked" of which "immediate unchecked" can't be * 
* used on a table with a generated column.                     * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.1 FP4                                      * 
****************************************************************

Drop the foreign keys, do admin_move_table, then reinstall the 
keys.

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

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC99952 
follow-up : 

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

07.08.2013
09.06.2014
09.06.2014