Skip to main content

RESET ENGINE

Clears any session-specific execution engine set using the SET ENGINE command. After clearing, query routing will revert to the default rules defined by Workload Management (WLM). This ensures that subsequent queries in the session follow standard WLM routing unless a new engine is explicitly set.

Syntax 
RESET ENGINE

Examples​

Each subsequent query in the same session will be routed according to the default WLM rules 
RESET ENGINE;