DB2 FOR LUW / DB2FORLUW / 970 - DB2

Customer has a table with security label on a column. 
 
After execute ADMIN_MOVE_TABLE stored procedure the table was 
moved but without the security label on column.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Recommendation: Upgrade to DB2 Version 9.7 Fix Pack 9        * 
****************************************************************

Manually create a target table with the same definition of the 
source table and then run ADMIN_MOVE_TABLE with the target table 
approach, for example, 
CALL 
ADMIN_MOVE_TABLE('TEST','TAB1','TAB1T','COPY_USE_LOAD,KEEP','MOV 
E'); 
For more information, see 
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.i 
bm.db2.luw.sql.rtn.doc/doc/r0055069.html

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 Version 9.7 Fix Pack 9

not known / see Local fix

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

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

26.07.2013
17.12.2013
17.12.2013

9.7.FP9