Logging rules are removed from DBC.DBQLRuleTbl and the rules cache. Logging based on those rules is discontinued.
Example: Remove all DBQL rules in effect from DBC.DBQLRuleTbl
To remove all DBQL rules in effect from DBC.DBQLRuleTbl and update all active sessions to remove any DBQL logging at the next request, submit this request.
END QUERY LOGGING ON ALL RULES;