If the SYSPROC.ADMIN_MOVE_TABLE failed due to SQL911N reason code 68 (lock timeout), and if you try cleaning the staging objects, you will receive SQL2104N reason code 4.
db2 "CALL SYSPROC.ADMIN_MOVE_TABLE('DATASTORE','EXCHANGEPOINT','TBA02000','TBX02000','TBL02000','','','','','','CLEANUP')"
SQL2104N The ADMIN_MOVE_TABLE procedure could not be completed at this time
by this user. Reason code: "4". SQLSTATE=5UA0M
At this stage, perform CANCEL instead of CLEANUP to clear the non-operational state.
db2 "CALL SYSPROC.ADMIN_MOVE_TABLE('DATASTORE','EXCHANGEPOINT','TBA02000','TBX02000','TBL02000','','','','','','CANCEL')"
Result set 1
--------------
KEY VALUE
-------------------------------- --------------------------------------------------------------------------------------------------------------------------------
0 record(s) selected.
Return Status = 0
