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.To set up resource
limits for a query:
Procedure
- 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. The Resource
Limits window opens.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.