QMF HPO/Manager is a family of utilities for managing and administering QMF. The QMF HPO/Manager comprises these integrated components:
This completely replaces the QMF sample governor and is the direct interface into QMF processing for the QMF HPO/Manager. This enhanced governor module is more than a QMF governor because it services the following facilities:
You can now produce lists of QMF objects that are based on the content of the object. Object Manager has a new list filter that allows you to locate queries that contain references to specific table names, column names, SQL verbs, and so on. Object Manager supports the migration and copying of objects to and from and QMF Version 7.2. It recognizes and appropriately handles the new columns in the OBJECT_DIRECTORY.
All Q.PROFILES environment values are supported, including CICS/MVS and CICS/VSE and CMS.
The governor controls QMF session activity. It obtains thresholds and controls from resource groups in the same way as the QMF sample governor, but provides a much wider and more flexible set of controls. These controls enforce the proper use of resources in QMF sessions.
The monitor supplies a real-time user interface to QMF session activity information. It accepts administrator commands and passes them to the Governor Module.
The query analyzer provides preemptive governing capabilities. It traps queries before DB2 processes them, and estimates their resource consumption. Query Analyzer can cancel queries that it judges to be too resource intensive.
The activity log provides a repository for QMF session activity and QMF object usage information. The Governor Module writes directly to the Activity Log data sets. You must run a batch job periodically to copy the Activity Log data sets to the Activity Log tables. You can use the Activity Log JCL function to create the JCL to run this batch job.
The online facilities help organize and simplify the administration and management of QMF HPO. You can review and manipulate QMF objects by using the Object Manager online facilities. Two types of actions are supported- those that operate on one object and those that can operate on a set of objects.
The QMF HPO/Manager helps you isolate production applications from query and reporting activities. A session activity list (shown below) gives administrators essential facts about database activity, the number of rows that are fetched, and processor time consumption.
DB2A -- Session Activity List ---------------------------------ROW 1 TO 5 OF 5
COMMAND ===> SCROLL ===> CSR
RAAM018I--monitor data refreshed
Valid Actions Are...
B Browse SQL Text
C Cancel Current Action
rows that are fetched
TSOID : VNDRSTRW
Mode : ONLINE C S
QMF Object Object A Q
A Date Time Act Owner Name Rows CPU N L
- -------- -------- --- -------- ------------------ ---------- ----------- - -
96/09/02 07:47:52 BEG 0 0
96/09/02 07:47:52 RUN VNDRSTRW MODELING 0 0
96/09/02 07:48:01 *** VNDRSTRW MODELING 100 00 00 00 23 0 Y
96/09/02 07:48:01 *** VNDRSTRW MODELING 1733 00 00 03 69 0
96/09/02 07:48:01 *** VNDRSTRW MODELING 3330 00:00:07:20 0
******************************** BOTTOM OF DATA ******************************Using the QMF HPO/Manager session activity list, QMF administrators can browse the SQL text associated with a query or cancel an active QMF command with database activity.