MOVE query

Move a query to another WLM resource pool.

MOVE query TO WLM RESOURCE POOL pool
where query refers to the ID of a running query and pool is the name of a resource pool in the active WLM configuration. For example:
premdb# move 17831 to wlm resource pool flexpool10;
MOVE

To get a list of currently running queries, select from the sys.query view.

A query can only be moved to a pool, or restarted in a pool, that is part of the currently active WLM configuration.

For more details, see Moving a Query to Another Pool.