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.
[ Previous Page | Next Page | Contents | Index ]