ADMIN_MOVE_TABLE_UTIL procedure - Modify the online move table procedure
The ADMIN_MOVE_TABLE_UTIL procedure works in conjunction with the SYSPROC.ADMIN_MOVE_TABLE stored procedure when moving active table data.
This stored procedure provides a mechanism to alter the user definable values in the ADMIN_MOVE_TABLE protocol table, which is created and used by the ADMIN_MOVE_TABLE procedure.
This procedure will only modify a value in the ADMIN_MOVE_TABLE protocol table if a table move for the table referenced by the TABSCHEMA and TABNAME parameters is already in progress, and the authorization ID of the caller of the procedure is the same as the user executing the table move.
Authorization
- EXECUTE privilege on the ADMIN_MOVE_TABLE_UTIL procedure
- DATAACCESS authority
- DBADM authority
- SQLADM authority
Default PUBLIC privilege
In a non-restrictive database, EXECUTE privilege is granted to PUBLIC when the procedure is automatically created.
Syntax
The schema for this stored procedure is SYSPROC.
Procedure parameters
- tabschema
- This input parameter specifies the name of the schema containing the table being moved. This name is case sensitive. and has a data type of VARCHAR(128).
- tabname
- This input parameter specifies the name of the table being moved. This parameter is case sensitive and has a data type of VARCHAR(128)
- action
- This input parameter specifies the action for the procedure to execute.
- key
- This input parameter specifies the key that to "upsert" or delete in the ADMIN_MOVE_TABLE protocol table.
- value
- This input parameter specifies the value to "upsert" into the ADMIN_MOVE_TABLE protocol table. This parameter has a data type of CLOB(10M). The parameter can be NULL or the empty string.
Usage notes
More information regarding the changeable KEY values in the ADMIN_MOVE_TABLE protocol table is available in the Usage notes section of the ADMIN_MOVE_TABLE procedure.
Examples
This example covers a basic call to the stored procedure in order to update the compression value and remove the specific index information used for the target table copying.
CALL SYSPROC.ADMIN_MOVE_TABLE('SVALENTI','T1','','','','','','','','','INIT')
Next,
update the DEEP_COMPRESSION_SAMPLE value to 30720 KB:CALL SYSPROC.ADMIN_MOVE_TABLE_UTIL('SVALENTI','T1','UPSERT',
'DEEPCOMPRESSION_SAMPLE','30720')
Now, delete the
COPY_INDEXSCHEMA and COPY_INDEXNAME values:CALL SYSPROC.ADMIN_MOVE_TABLE_UTIL('SVALENTI','T1','DELETE','COPY_INDEXSCHEMA','')
CALL SYSPROC.ADMIN_MOVE_TABLE_UTIL('SVALENTI','T1','DELETE','COPY_INDEXNAME','')
After
these changes, continue the ADMIN_MOVE_TABLE procedure using the new
values in the meta table:CALL SYSPROC.ADMIN_MOVE_TABLE('SVALENTI','T1','','','','','','','','','COPY')
CALL SYSPROC.ADMIN_MOVE_TABLE('SVALENTI','T1','','','','','','','','','REPLAY')
CALL SYSPROC.ADMIN_MOVE_TABLE('SVALENTI','T1','','','','','','','','','SWAP')