Setting up query resource limits

You can set up one or more unique sets of resource limits that can be applied to an individual query.

About this task

Each time a user runs the query at any data source, the resource limits assigned to the user will control their resource consumption at that data source. Each set of resource limits can place specific restrictions that can be implemented based on the time of day or day of week that the query is run. You can apply resource limits to any query that has been saved in a repository. The resource limits that you can apply to a query are the Timeouts, LOBs, and Cache resource limits. For more information on setting up resource limits, see USRPIIsetresourcelimit.html.

To set up resource limits for a query:

Procedure

  1. From the Repository Explorer or Repositories view, right-click a query that has been saved in the repository. Select Properties from the pop-up menu. The Properties for [query name] window opens. Click the Resource Limits folder. Alternately, you can open the Resource Limits window from the Query Strings for Result Set toolbar button.
    The Resource Limits window opens.
  2. All resource limits groups that exist for a query are listed in the Resource limits groups list box. Every data source has a resource limits group called Default. The Default resource limits group includes all users and has no resource limitations. Use the Show resource limits groups whose names match field and the Refresh List button to search for specific resource limits groups that exist on the data source. Use a percent (%) sign in the Show resource limits groups whose names match field to list all resource limits groups that exist on the data source.
  3. Create a new resource limits group for the data source by clicking the Add icon. The New Resource Limits Group window opens. Specify field values and click OK.
  4. Create a schedule and specify resource limit values for the resource limits group by selecting the resource limits group from Resource limits groups list box and clicking the Edit icon. The Edit Resource Limits Group Schedule window opens. Specify field values and click OK.
  5. Assign users to a resource limits group by selecting the resource limits group from the Resource limits groups list box and clicking Assign. If you are using a repository as your resource limits provider, the Assignment for [resource limits group name] window opens. If you are using a QMF catalog as your resource limits provider, the Assign User Profiles to [resource limits group name] window opens. Specify field values and click OK.
  6. To delete a resource limits group, select the group from Resource limits groups list box and click the Delete icon. The resource limits group is removed from Resource limits groups list box.
  7. Click OK to close the Resource Limits page of the Properties window.
    Note: If a resource limit has been set at the query level and the data source level, QMF will apply the most restrictive limit of the two. For example, if the Maximum Rows to Fetch limit is set to 150,000 rows at the query level, but set to 100,000 rows at the data source level, then QMF will apply the data source limit of 100,000 rows when the query is run, since the lower number constitutes a more restrictive limit. This selection process is repeated for every resource limit that is set at both the query and data source levels.