The MON_GET_EXTENT_MOVEMENT_STATUS table function returns the status of the extent movement operation.
None
SELECT * FROM TABLE(SYSPROC.MON_GET_EXTENT_MOVEMENT_STATUS('', -1))
TBSP_NAME TBSP_ID MEMBER CURRENT_EXTENT LAST_EXTENT NUM_EXTENTS_MOVED
--------- ------- ------ -------------- ----------- -----------------
SYSCATSPACE 0 0 -1 -1 -1
TEMPSPACE1 1 0 -1 -1 -1
USERSPACE1 2 0 -1 -1 -1
TS1 3 0 1 2 3
SYSTOOLSPACE 4 0 -1 -1 -1
5 record(s) selected.
... NUM_EXTENTS_LEFT TOTAL_MOVE_TIME ADDITIONAL_DETAILS
... ---------------- --------------- ------------------
... -1 -1 -
... -1 -1 -
... -1 -1 -
... 4 0 -
... -1 -1 -
Column Name | Data Type | Description or corresponding monitor element |
---|---|---|
TBSP_NAME | VARCHAR(128) | tablespace_name - Table space name |
TBSP_ID | BIGINT | tablespace_id - Table space identifier |
MEMBER | SMALLINT | member - Member from which this information was collected. |
CURRENT_EXTENT | INTEGER | current_extent - Current extent being moved |
LAST_EXTENT | INTEGER | last_extent - Last extent moved |
NUM_EXTENTS_MOVED | INTEGER | num_extents_moved - Number of extents moved so far during this extent movement operation |
NUM_EXTENTS_LEFT | INTEGER | num_extents_left - Number of extents left to move during this extent movement operation |
TOTAL_MOVE_TIME | BIGINT | total_move_time - Total move time for all extents moved (in milliseconds) |