|
Problem IC88671
|
Status: Closed |
ADMIN_MOVE_TABLE TO TERMINATE BROKEN LOAD AND RESTART A NEW LOAD |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
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. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.1 Fix Pack 2. *
**************************************************************** |
| Local Fix: |
n/a |
| available fix packs: |
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 Version 10.1 Fix Pack 2. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.11.2012
27.12.2012
27.12.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.2
|
 |
| 10.5.0.2
|
|
