Defining your own resource limits
To set your own resource limits for the number of rows that are retrieved from the database, you can add a resource group to the resource control table.
About this task
This procedure adds a resource group named GROUP1. The governor prompts users in GROUP1 when the number of rows reaches 10,000 and cancels the user's activity when the number of rows reaches 15,000. For TSO, ISPF, and native z/OS® batch, the governor also prompts a user in GROUP1 when processor time reaches 300 seconds, and cancels the user’s activity when the processor time reaches 1,000 seconds. The procedure also shows an example of how to add a user to a resource group.
To add a resource group to the resource control table, follow these steps:
- Set the number of rows at which the user is warned of the
approaching resource limit. If you do not want to warn users when they are approaching their limit for the number of rows, skip to Step 2.
- Set the number of rows at which the
governor cancels the user's activity. The following example sets the cancellation at 15,000 rows.
- Set the processor time that elapses before the user is
warned of the approaching resource limit. Elapsed processor time applies only to TSO, ISPF, and native z/OS batch environments. If you do not want to warn users when they are approaching their limit for the time that is elapsed, skip to Step 4.
- Set the amount of processor time that
can elapse before the governor cancels the user's activity.
- Set the real time between intervals when the governor checks
the user's activity.
- Turn on governing for the GROUP1 resource group. SCOPE is a resource option that activates or deactivates governing. Each resource group in Q.RESOURCE_TABLE must have a RESOURCE_OPTION called SCOPE, and SCOPE must have a corresponding INTVAL of zero, or the resource group is not governed. Set INTVAL to 1 to deactivate governing.
- Add user JONES to the GROUP1 resource group in the English QMF environment.
Use a similar statement to update user profiles in an NLF environment, but use a value for
TRANSLATIONthat represents the name that QMF uses for the NLF. For the name that QMF uses for an NLF, see Table 1
What to do next
Instruct the user whose profile you updated to end the current QMF session and start another to activate the new values.