Activating the default limits
You can set up the governor exit routine to warn a user when the number of rows retrieved from the database reaches 25,000 and to cancel QMF activity when the number of rows retrieved reaches 100,000.
About this task
- Enter the statement shown in Figure 1 on
the SQL Query panel and issue the RUN QUERY command
to update the Q.RESOURCE_VIEW table.
- Unless you have started QMF with
a value of TSOID for the DSQSPRID parameter, set a value of SYSTEM
for the RESOURCE_GROUP field of the user's profile. Important: Always specify a value for the TRANSLATION column, or you might change more rows in the Q.PROFILES table than you intend.
For example, the UPDATE statements in Table 1 activate default values for user JONES (using English QMF) and user SCHMIDT (using German QMF).
If you have started QMF with a DSQSPRID value of TSOID, the resource group name is the user's TSO user ID.
The resource group in use for the user's QMF session is recorded in the DSQAP_RESOURC_GRP global variable.
Table 1. Updating a user's resource group to use the default resource limits Base QMF (English) German NLF
UPDATE Q.PROFILES SET RESOURCE_GROUP = 'SYSTEM' WHERE CREATOR='JONES' AND TRANSLATION='ENGLISH'
UPDATE Q.PROFILES SET RESOURCE_GROUP = 'SYSTEM' WHERE CREATOR='SCHMIDT' AND TRANSLATION='DEUTSCH'
What to do next
Instruct users to reconnect to the database to activate the new values. This can be done with a QMF CONNECT command, or they can end the current QMF session and begin another to activate the new resource group.