Setting up data source resource limits

You can set up one or more unique sets of resource limits that can be applied to individual users or to groups of users when they access a data source.

1. From the Repository Explorer view, right-click a relational data source. Select Properties from the pop-up menu. The Properties for [data source] window opens. Click Resource Limits. The Resource Limits window opens.
2. All resource limits groups that exist for a data source 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 Add. The New Resource Limits Group window opens. Specify field values and click OK.
   Note: The Add button is always available for the data sources with the QMF Catalog resource limits provider. However, if the limits are stored in a repository instead of a QMF Catalog, then Add is available only for the data sources that exist in secured repositories.
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 Edit. The Edit Resource Limits Group 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.
   Note: The Assign button is available only in the following scenarios:

   • You are using a repository as your resource limits provider and the data source that you are working with exists in a secured repository.
   • You are using a QMF Catalog as your resource limits provider.
6. To delete a resource limits group, select the group from Resource limits groups list box and click Delete. The resource limits group is removed from Resource limits groups list box.
   Note: The Delete button is always available for the data sources with the QMF Catalog resource limits provider. However, if the limits are stored in a repository instead of a QMF Catalog, then Delete is available only for the data sources that exist in secured repositories.
7. Click OK to close the Resource Limits page of the Properties window.
   Note: If a resource limit has been set at the data source level in QMF Server and at the query level in QMF clients, 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.