|
Problem IT38564
|
Status: Closed |
ADMIN_MOVE_TABLE(REPORT) OPERATION FAILS WITH -911 LOCK TIMEOUT DURING ADMIN_MOVE_TABLE(COPY_USE_LOAD)
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
When an ADMIN_MOVE_TABLE operation is invoked with the
COPY_USE_LOAD option, and the target table being Loaded has
constraints defined, then an ADMIN_MOVE_TABLE(REPORT) operation
may fail with a -911 lock timeout error when the Load operation
is running.
This is due to the Load operation retaining an X row-lock on the
sysibm.systables catalog table for the duration of the Load,
preventing the ADMIN_MOVE_TABLE(REPORT) operation from accessing
the information in this row. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to fix/mod-pack inclusive of this APAR fix. *
**************************************************************** |
| Local Fix: |
N/A |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to fix/mod-pack inclusive of this APAR fix. *
**************************************************************** |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 30.09.2021
28.11.2021
28.11.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
