DB2 FOR LUW / DB2FORLUW / 970 - DB2

The procedure SYSPROC.ADMIN_MOVE_TABLE might hang if all the 
following conditions are true: 
- Multiple SYSPROC.ADMIN_MOVE_TABLE operations run concurrently. 
- The operation parameter of at least one concurrent run of 
SYSPROC.ADMIN_MOVE_TABLE is SWAP or CLEANUP. 
- The operation parameter of at least one other concurrent run 
of SYSPROC.ADMIN_MOVE_TABLE is INIT, SWAP or CLEANUP. 
 
This defect might cause the SAP tool DB6CONV to hang because 
DB6CONV runs SYSPROC.ADMIN_MOVE_TABLE more than once 
concurrently.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of DB2 for Linux, UNIX and Windows                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* .                                                            * 
****************************************************************

To prevent any possibility of the problem happening you can 
avoid running SYSPROC.ADMIN_MOVE_TABLE with the SWAP or CLEANUP 
operation at the same time as SYSPROC.ADMIN_MOVE_TABLE is 
running concurrently with the INIT, SWAP or CLEANUP operation.

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
 

Problem was first fixed in Version 9.7 Fix Pack 4. 
At a minimum, this fix should be applied on the database 
 
server.

To prevent any possibility of the problem happening you can 
avoid running SYSPROC.ADMIN_MOVE_TABLE with the SWAP or CLEANUP 
operation at the same time as SYSPROC.ADMIN_MOVE_TABLE is 
running concurrently with the INIT, SWAP or CLEANUP operation.

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

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

07.01.2011
24.05.2011
24.05.2011

9.7.FP4