QMF commands that can be monitored by the Db2 governor

You can monitor QMF commands with the Db2® governor.

Each row in the following table represents a group of QMF commands that can be individually monitored by the Db2 governor. Read the description of each package in the third column of the table to determine the proper package to govern according to your QMF configuration.

Package names for which the descriptions refer to systems other than Db2 for z/OS® are used to govern SQL statements at remote servers, which are accessed by the QMF CONNECT command or QMF commands that include three-part names. To use the Db2 resource limit facility to govern SQL statements at remote servers, additional configuration steps are required to set up governing.
Table 1. Groups of QMF commands that can be individually monitored by the Db2 governor
QMF command Type of statement governed QMF package names to govern
  • RUN QUERY (QBE P. queries, prompted queries, and SQL SELECT queries)
  • DISPLAY TABLE (CONFIRM=YES)
  • EXPORT TABLE
  • PRINT TABLE
  • Commands that scroll reports (BOTTOM, TOP, FORWARD, BACKWARD, RIGHT, and LEFT)
 SELECT
  • DSQKFSUS - controls single row fetch operations, which apply when QMF is started in a Db2 for z/OS, DB2® for iSeries, or Db2 for Linux®, UNIX, and Windows database with the MR program parameter set to NO
  • DSQKFSUM - Controls multirow fetch operations, which apply when QMF is started in a Db2 for z/OS database with the MR program parameter set to YES
  • DSQKFSUV - Controls fetching of rows from a DB2 for VSE and VM database
  • SAVE DATA
  • IMPORT TABLE
 INSERT
  • DSQKSDT7 – Controls single row insert operations, which apply when QMF is started in a Db2 for z/OS, DB2 for iSeries, or Db2 for Linux, UNIX, and Windows database with the MR program parameter set to NO.

    Single row insert is also used when a SAVE DATA command is issued to save a table that contains XML or LOB data.

  • DSQKSDT8 – Controls multirow insert operations, which apply when QMF is started in a Db2 for z/OS database with the MR program parameter set to YES
RUN QUERY (QBE I., U., or D. queries or SQL queries that include INSERT, UPDATE, or DELETE statements)
INSERT
UPDATE
DELETE
  • DSQKESQL – For DB2 for VSE and VM databases
  • DSQKESQM – For all other database types
EDIT TABLE (MODE=ADD) INSERT DSQKTSQL
EDIT TABLE (MODE=CHANGE, SAVE=IMMEDIATE)
UPDATE
DELETE
 DSQKHSQL
EDIT TABLE (MODE=CHANGE, SAVE=END)
UPDATE
DELETE
 DSQKNSQL (DB2 for VSE and VM only)