DB2 graphic QMF Version 8

Query Analyzer

Query Analyzer provides you with preemptive governing capabilities needed to automatically prohibit resource intensive or inefficient QMF queries from being processed by DB2. By providing you with a resource profile for your query that is more meaningful than the TIMERON value, you can make decisions about whether a query should run or be canceled before it runs.

Even though you can also use Query Analyzer outside of QMF to interpret a query's access path efficiency without running it, this facility is primarily designed to be a preemptive governor for QMF.

The primary components of Query Analyzer are access path reporting, historical QMF query statistics, and an exit routine to allow conditional processing of the query based on the above information. The HPO/Governor module provides Query Analyzer's direct interface into QMF processing.


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