Setting query limits
Under the Limits tab for a workgroup, you can add a limit to monitor performance and limits. For more information about query monitoring limits, see WLM query monitoring rules.
-
Choose Manage query limits. Choose Add new limit on the Manage query limits dialogue.
-
Choose the limit type you want to set and enter a value for its corresponding limit.
-
Choose Save changes to save the limit.
When you change your query limit and configuration parameters, your database will restart.