DO_TM_TASK
Runs a Tuple Mover (TM) operation and commits current transactions. You can limit this operation to a specific table or projection. When started using this function, the TM uses the GENERAL resource pool instead of the TM resource pool.
Syntax
DO_TM_TASK('task'[, '[[database.]schema.]{ table | projection}]' )
Parameters
task
|
Specifies one of the following tuple mover operations:
|
[database.]schema
|
Database and schema. The default schema is |
table | projection
|
Applies task to the specified table or projection. If you specify a projection and it is not found, DO_TM_TASK looks for a table with that name and, if found, applies the task to it and all projections associated with it. 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');