Use the END QUERY LOGGING ON ALL RULES statement to eliminate all rules currently in the DBQLRuleTbl table using the ON ALL RULES option. For example:
END QUERY LOGGING ON ALL RULES;
The system will:
- Delete rules from the DBQLRuleTbl.
- Set the DBQLRuleCountTbl.NumberOfRules field to 0.
- Flush all rules caches.