DB2 FOR LUW / DB2FORLUW / 970 - DB2

ADMIN_MOVE_TABLE may receive a "SQL2105N Reason Code: 25" error 
which means that it does not allow to move tables with LOB 
columns that does not have a unique index. That is an 
unnecessary limitation.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All using large objects being moved with ADMIN_MOVE_TABLE    * 
* function                                                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* see error description above                                  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to 9.7 fixpack 4 or above                            * 
****************************************************************

Create a unique index for the LOB columns.

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 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
 

First fixed in version 9.7 Fixpack 4

keiner bekannt / siehe Local-Fix

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

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

14.10.2010
28.04.2011
28.04.2011

9.7.FP4