DB2 graphic  QMF Version 8

Resource limits

Resource limits are part of QMF for Windows governing, the feature that helps you manage database server resource consumption. You implement QMF for Windows governing by setting limits on a user's access to a database server. The limits that you set are called resource limits.

QMF for Windows resource limits are checked before a query leaves the workstation. The query never reaches a database server for evaluation if a resource limit is violated. There are some QMF for Windows resource limits that are invoked after the query is running, such as rows returned or database server timeouts. QMF for Windows resource limits do not overrule any database server specifications.

There are four steps to setting up QMF for Windows governing:

  1. Create a resource limits group.
  2. Create a schedule that identifies when the resource limits specified for the group will be in effect.
  3. Specify the individual resource limits that will be in effect during the schedule.
  4. Assign users to the resource limits group.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004