DB2 FOR LUW / DB2FORLUW / 970 - DB2

ADMIN MOVE TABLE REPLAY PHASE FAILS ON TABLES WITH UNIQUE 
COLUMNS DUE TO UNIQUE CONSTRAINT VIOLATION 
 
During the REPLAY stage of Admin move table the procedure may 
fail with a SQL0903N error like the following 
 
SQL0803N  One or more values in the INSERT statement, UPDATE 
statement, or foreign key update caused by a DELETE statement 
are not valid because the primary key, unique constraint or 
unique index identified by "2" constrains table 
"TESTPROC.T42AAAFdyt" from having duplicate values for the index 
key.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All Users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* ADMIN MOVE TABLE REPLAY PHASE FAILS ON TABLES WITH           * 
* UNIQUECOLUMNS DUE TO UNIQUE CONSTRAINT VIOLATIONDuring the   * 
* REPLAY stage of Admin move table the proceduremay fail with  * 
* a SQL0903N error like the followingSQL0803N  One or more     * 
* values in the INSERT statement, UPDATEstatement, or foreign  * 
* key update caused by a DELETEstatement are not valid because * 
* the primary key, uniqueconstraint or unique index identified * 
* by "2" constrainstable"TESTPROC.T42AAAFdyt" from having      * 
* duplicate values for theindex key.                           * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to version 9.7 Fixpak 2 or later              * 
****************************************************************

This problem occurs only during the REPLAY phase. If there has 
been no activity on the table since the ADMIN MOVE TABLE 
operation started there will be no rows to replay and the 
problem won't be hit.

DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem is first fixed in Version 9.7 Fixpak 2

not known / see Local fix

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

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

16.03.2010
22.06.2010
22.06.2010

9.7.