Viewing acceleration resource limits

QMF resource limits control your data source access and resource consumption.

About this task

You can view the resource limits that are in effect for your user ID. You must be connected to the data source in order to view the resource limits that are in effect for your user ID when you access that data source.

To view resource limits for your user ID:

Procedure

  1. Select View > Resource Limits. The [Data Source]: Limits window opens.
    The information in the Active Resource Limits section shows whether the limits displayed are data source limits or query limits, and to what user and resource limit group they are applied.
  2. Select the Timeouts page to see the warning and cancellation limits for idle queries, idle connections, and server response time that have been set for your user ID.
  3. Select the Limits page to see the warning and cancellation limits for the maximum number of rows and bytes of data that can be retrieved using your current user ID and the maximum number of simultaneous connections QMF can establish to the database server for your user ID.
  4. Select the SQL Verbs page to see the SQL verbs that your user ID is allowed to use when a particular schedule is in effect.
  5. Select the Options page to see what server access options have been set for your user ID. The server access options include: database access using the QMF user interface and programming interface; database update confirmation; isolation levels for user queries; mandatory account information; and the ability to fetch all rows automatically, export data, edit tables, and only run saved queries.
  6. Select the Save Data page to see if you are allowed to save data at the database.
  7. Select the Binding page to see if you are allowed to bind or drop static packages for your queries.
  8. Select the Object Tracking page to see if QMF object tracking is activated for your user ID.
  9. Select the LOB Options page to see if you can access and retrieve data from tables containing large object data (LOB).
  10. Select the Cache page to control caching options for each user.
  11. Select the Object list page to define the default owner name to be used to filter data source objects.
  12. Select the Acceleration page to view acceleration options.
    Note: Acceleration is available only for Db2 for z/OS databases that support IDAA.
  13. Click OK to close the Resource Limits for [user ID] window.