DB2 FOR LUW / DB2FORLUW / 980 - 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 UNIQUE    * 
* COLUMNS DUE TO UNIQUE CONSTRAINT VIOLATION                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to Version 9.8 Fixpack 3 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.8 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.8 Fix Pack 4 for AIX and Linux
 DB2 Version 9.8 Fix Pack 5 for AIX and Linux
 

Problem was first fixed in Version 9.8 Fixpack 3

not known / see Local fix

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

19.03.2010
21.12.2010
21.12.2010

9.8.FP3