Other / Table Movement
Purpose
Table movement view shows the procedue information of table movement. This view could be used to check the status information and configuration options related to the table to be moved.
Screenshot
Metric shown
Schema
The schema of the table.
Source: SYSTOOLS.ADMIN_MOVE_TABLE.TABSCHEMA
Table name
The name of the table.
Source: SYSTOOLS.ADMIN_MOVE_TABLE.TABNAME
Status
Displays the current status of the online table move:
- INIT: INIT is in progress
- COPY: COPY is in progress or is possible
- REPLAY: REPLAY is in progress or REPLAY and SWAP are possible
- CLEANUP: MOVE is complete, but cleanup has not finished or CLEANUP is possible
- CANCEL: CANCEL is in progress, but cancel has not finished or CANCEL is possible
- COMPLETE: MOVE and CLEANUP are complete
- COMPLETE_WITH_WARNINGS: MOVE and CLEANUP are complete, however there are warnings (listed under the WARNINGS key).
Source: SYSTOOLS.ADMIN_MOVE_TABLE.STATUS
Cleanup start
Displays the CLEANUP phase start time.
Cleanup end
Displays the CLEANUP phase end time.
Source: SYSTOOLS.ADMIN_MOVE_TABLE.CLEANUP_END
Copy start
Displays the COPY phase start time.
Source: SYSTOOLS.ADMIN_MOVE_TABLE.COPY_START
Copy end
Displays the COPY phase end time.
Source: SYSTOOLS.ADMIN_MOVE_TABLE.COPY_END
Copy total rows
Displays the total number of rows copied during the COPY phase.
Replay total time
Displays the accumulated time in seconds used for replaying rows.
Replay total rows
Displays the accumulated number of replayed rows.
Swap start
Displays the SWAP phase start time.
Source: SYSTOOLS.ADMIN_MOVE_TABLE.SWAP_START
Swap end
Displays the SWAP phase end time.
Source: SYSTOOLS.ADMIN_MOVE_TABLE.SWAP_END