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.
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.
Figure 1. Activating default values
for the governor supplied by IBM®
UPDATE Q.RESOURCE_VIEW
SET INTVAL=0
WHERE RESOURCE_OPTION=’SCOPE’ AND
RESOURCE_GROUP=’SYSTEM’
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.