DB2 FOR LUW / DB2FORLUW / 970 - DB2

Steps to reproduce: 
- issue HADR takeover while ADMIN_MOVE_TABLE is in progress. 
- on the new HADR primary calls to ADMIN_MOVE_TABLE for the same 
table may return: 
SQL2104N  The ADMIN_MOVE_TABLE procedure could not be completed 
at this time by this user.  Reason code: "9".  SQLSTATE=5UA0M 
 
Workaround: 
Remove the LOCK from ADMIN_MOVE_TABLE protocol table manually. 
Then you can either continue or cancel the ADMIN_MOVE_TABLE that 
is still in progress.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Using ADMIN_MOVE_TABLE in HADR environment.                  * 
* DB2 9.7 GA or later                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Remove ADMIN_MOVE_TABLE LOCK manually.                       * 
****************************************************************

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
 

ADMIN_MOVE_TABLE LOCK will get automatically removed after a 
HADR takeover as it done today after a database restart.

keiner bekannt / siehe Local-Fix

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

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

29.03.2012
05.06.2012
05.06.2012