DB2 FOR LUW / DB2FORLUW / 970 - DB2

ADMIN_MOVE_TABLE fails with following error, when there are two 
indexes on the same column: 
 
SQL2103N  The ADMIN_MOVE_TABLE procedure could not be completed 
because some aspect of either the source table or target table 
is not supported  by the ADMIN_MOVE_TABLE procedure.  Reason 
code: "17".  SQLSTATE=5UA0M 
 
The problem is re creatable as follows: 
 
 
CREATE TABLE "ihubv97  "."tab1"  ("NUM" VARCHAR(12) NOT NULL  ) 
 
CREATE INDEX "ihubv97  "."abc" ON "ihubv97"."tab1" ("NUM" ASC); 
 
CREATE UNIQUE INDEX "ihubv97  "."xyz" ON "ihubv97 "."tab1" 
("NUM" ASC); 
 
CALL SYSPROC.ADMIN_MOVE_TABLE('ihubv97  ', 'tab1', 'USERSPACE1', 
'USERSPACE1', 'USERSPACE1', '', '', '', '', '', 'MOVE') 
 
The above command fails with error: SQL2103N

**************************************************************** 
* USERS AFFECTED:                                              * 
* Customer using ADMIN_MOVE_TABLE  can be affected by this     * 
* APAR                                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to the latest version of DB2 V97 or above.    * 
****************************************************************

To create the "UNIQUE" index first and then the other index.

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 8 for Linux, UNIX, and Windows
 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
 

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC84547 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

08.08.2011
04.09.2012
04.09.2012

9.7.