Configuring Db2 governing of QMF commands

You configure the governing of QMF commands directed to the local Db2® for z/OS® database by adding rows to a specific resource limit specification table (RLST).

When the Db2 for z/OS subsystem in which QMF is installed is started, the subsystem is associated with a specific RLST. An RLST provides the Db2 governor with input for all the users in the subsystem with which the RLST is associated, including QMF users.

Different RLSTs can be associated at different times with the same Db2 subsystem. For example, one RLST for a particular period of time might make it impossible for users to start a QMF session during that period of time; in these cases, any attempt to start a QMF session ends during QMF initialization, and a message appears in the trace data. You can use different RLSTs to handle site-specific rules and restrictions or provide governing for individual users or groups of users. For example, you can add rows for a few individual users and a row that applies to everyone else. The rows for the individual users contain their primary authorization IDs. The row for the other users contains a blank value for the authorization ID.

To configure governing of QMF commands directed to the local Db2 for z/OS database, add one row to the Db2 RLST for each package shown in QMF commands that can be monitored by the Db2 governor that you want to govern. The columns to be updated in the RLST depend on whether you want to govern QMF commands predictively or reactively. More than one row can be associated with a QMF package name if both predictive and reactive governing are required for the package.

To use the Db2 resource limit facility to govern SQL statements at remote servers, additional configuration steps are required.

How to update RLSTs for predictive governing

For predictive governing, update the following columns of the RLST table:

Table 1. Values to add to the Db2 for z/OS RLST table to predictively govern QMF commands
Column of RLST table	Value
RLFPKG	The name of the package associated with the QMF commands to be governed Package names are shown in QMF commands that can be monitored by the Db2 governor.
RLFFUNC	7
RLFASUERR	User-determined
RLFASUWARN	User-determined
RLF_CATEGORY_B	User-determined

How to update RLSTs for reactive governing

For reactive governing, update the following columns of the RLST table:

Table 2. Values to add to the Db2 for z/OS RLST table to reactively govern QMF commands
RLST column	Value
RLFPKG	The name of the package associated with the QMF commands to be governed. Package names are shown in QMF commands that can be monitored by the Db2 governor.
RLFFUNC	2
ASUTIME	Maximum processor time to be allocated to completing the QMF command associated with the package in RLFPKG

Important: Do not update the RLFCOLLN column of the RLST table. Attempting to govern QMF functions by the QMF collection ID (Q) can stop QMF internal processing in certain situations or otherwise cause QMF to function improperly.