Monitoring the resources

The DB2 governor monitors the processor time consumed running certain queries. The queries it monitors are the dynamically run SELECT, INSERT, UPDATE, and DELETE queries. In a QMF session, this includes all queries of these types that are run in the following ways:

Using the QMF RUN command

The queries run might be SQL, QBE, or prompted queries. For QBE and prompted queries, the governor monitors the equivalent SQL queries.

Using other QMF commands

In support of other commands, QMF creates and runs SQL queries on behalf of the user. For example, among these queries are the SELECT queries that QMF runs in response to DISPLAY table commands.

Running the Table Editor

In support of the Table Editor, QMF creates and runs SQL queries on behalf of the user. For example, among these queries are the SELECT queries that QMF runs in response to SEARCH commands.