DB2 graphic  QMF Version 8

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. These commands do not present a prompt screen in response to +495 SQL codes.
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.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004