Monitoring and governing QMF activity with QMF HPO/Manager
QMF HPO/Manager is a family of utilities for managing and administering QMF for TSO and CICS® operations.
The QMF HPO/Manager comprises the following integrated components:
- Governor module
- This module replaces the default governor exit
routine provided with QMF for TSO and CICS and
is the direct interface to QMF processing
for the QMF HPO/Manager. This
enhanced governor module is more than a QMF governor
because it services the following facilities:
- Object manager
The object manager tracks QMF session activity. It records information about the commands and objects and writes this information directly to the activity log.
You can also produce lists of QMF objects that are based on the content of a specific object. The object manager has a list filter that allows you to locate queries that contain references to specific table names, column names, SQL verbs, and so on. The object manager supports the migration and copying of objects to and from QMF for TSO and CICS. It recognizes and appropriately handles columns in the QMF for TSO/CICS Q.OBJECT_DIRECTORY table.
- Governor
The governor controls QMF session activity. It obtains thresholds and controls from resource groups in the same way as the QMF for TSO and CICS default governor, but provides a wider and more flexible set of controls. These controls enforce the proper use of resources in QMF sessions operating under TSO and CICS.
- Monitor
The monitor supplies a real-time user interface to information about QMF session activity in TSO and CICS. It accepts administrator commands and passes them to the HPO governor module.
- Query analyzer
The query analyzer provides preemptive governing capabilities. It traps queries before Db2® processes them and estimates their resource consumption. The query analyzer can cancel queries that are estimated to be too resource-intensive.
- Object manager
- Activity log
- 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's JCL function to create the JCL to run this batch job.
- Online facilities
- The online facilities help organize and simplify the administration and management of QMF HPO. You can review and manipulate QMF for TSO and CICS objects by using the object manager's online facilities. Two types of actions are supported: those that operate on one object and those that can operate on a set of objects.
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
- -------- -------- --- -------- ------------------ ---------- ----------- - -
05/09/10 07:47:52 BEG 0 0
05/09/10 07:47:52 RUN VNDRSTRW MODELING 0 0
05/09/10 07:48:01 *** VNDRSTRW MODELING 100 00 00 00 23 0 Y
05/09/10 07:48:01 *** VNDRSTRW MODELING 1733 00 00 03 69 0
05/09/10 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 that is associated with database activity.