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 thesys.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.

Parent topic:SQL Commands