DB2 FOR LUW / DB2FORLUW / 970 - DB2

ADMIN_MOVE_TABLE might fail with: 
SQL0601N  The name of the object to be created is identical to 
the existing name "SYSTOOLS.ADMIN_MOVE_TABLE" of type "TABLE". 
SQLSTATE=42710 
 
This can happen when more than one ADMIN_MOVE_TABLE is being run 
on the database when this routine was never called before. When 
ADMIN_MOVE_TABLE procedure is run for the first time on given 
database, it creates protocol table ADMIN_MOVE_TABLE in SYSTOOLS 
schema as the very first step. If multiple ADMIN_MOVE_TABLE are 
started concurrently and SYSTOOLS.ADMIN_MOVE_TABLE hasn't been 
created yet, there is a small timing hole when one or more of 
those run might fail with SQL0601N error. 
This APAR will change that behavior and ADMIN_MOVE_TABLE will no 
longer fail in such scenario.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7 Fix Pack 11 or higher.            * 
****************************************************************

Retry ADMIN_MOVE_TABLE

Problem first fixed in DB2 version 9.7 Fix Pack 11.

not known / see Local fix

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

04.03.2015
06.10.2015
06.10.2015

9.7.FP11