DB2 FOR LUW / DB2FORLUW / A10 - DB2

If ADMIN_MOVE_TABLE is run twice without data being inserted 
between the moves then columns set as GENERATE ALWAYS AS 
IDENTITY will not have their restart values set to the correct 
number. 
 
This is due to ADMIN_MOVE_TABLE retrieving the restart value 
from SYSCAT.COLIDENTATTRIBUTES, however 
SYSCAT.COLIDENTATTRIBUTES only gets set correctly after data has 
been inserted into the table.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 and Fix Pack 4                   * 
****************************************************************

Insert data into the table before running ADMIN_MOVE_TABLE the 
second time, or run ALTER TABLE with "GENERATE RESTART WITH" to 
reset the column with the correct value after the second move.

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Problem was first fixed in DB2 Version 10.1 and Fix Pack 4

keiner bekannt / siehe Local-Fix

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

24.02.2014
02.06.2014
02.06.2014