DB2 FOR LUW / DB2FORLUW / 970 - DB2

ADMIN_MOVE_TABLE (AMT) might hit conditions that cause the LOAD 
operation to finish prematurely. 
For example one might hit a log full condition (SQL0964C The 
transaction log for the database is full.) during LOAD 
operation. 
This will leave the target table in load pending state. 
 
With the current implementation AMT does no allow restart of the 
LOAD operation. 
Therefore a CANCEL (AMT) followed by new INIT and MOVE is needed 
to perform a new LOAD operation as soon as the error causing 
condition has been solved. 
 
This APAR will enable AMT to TERMINATE a broken LOAD and restart 
a new LOAD without the need to CANCEL the whole AMT operation.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 7.                       * 
****************************************************************

n/a

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 Fix Pack 7.

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC88671 
follow-up : 

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

09.03.2012
30.10.2012
30.10.2012

9.7.FP7