DO_TM_TASK
Runs a Tuple Mover operation on the specified table or projection and commits current transactions.
Syntax
DO_TM_TASK('task'[, '[[database.]schema.]{ table | projection} ]' )
Parameters
task |
Specifies one of the following tuple mover operations:
|
[database.]schema |
Specifies a schema, by default myschema.thisDbObject If you specify a database, it must be the current database. |
table | projection |
Applies task to the specified table or projection. If you specify a projection and it is not found, If you specify no table or projection, the task is applied to all database tables and their projections. |
Privileges
- Schema: USAGE
- Table: One of INSERT, UPDATE, or DELETE
Examples
Perform mergeout on all projections of table t1
:
=> SELECT DO_TM_TASK('mergeout', 't1');
Perform moveout on projection t1_proj
:
=> SELECT DO_TM_TASK('moveout', 't1_proj');