DB2 graphic QMF Version 8

Step 12f. Set the HPO/Governor module configuration parameters

These parameters are used in QMF by the HPO/Governor module for object tracking, monitoring, and customized help processing.

Table 120. HPO/Governor Module Configuration
DB2P -- HPO/Governor Module Configuration ---------------------------- 8.1.0
Command ===>
 
Press ENTER to proceed to the next configuration panel.
Type CAN or CANCEL or press PF3 to cancel configuration.
 
1. HPO Activity Log Data Set Names...
      TSO Activity......... ===>
      TSO SQL Text......... ===>
      CICS Activity........ ===>
      CICS SQL Text........ ===>
      Sort/Merge........... ===>
      Activity Archive..... ===>
      SQL Text Archive..... ===>
2. Number of Additional TSO Activity and SQL Text Log Data Sets ===>
3. CICS Transient Data Queue Names...
      CICS Activity Log.... ===>
      CICS SQL Text Log.... ===>
4. VSAM File Names...
      Monitor.............. ===>
5. CPU Time Threshold for SQL Text Monitoring (in seconds).... ===>
6. Enable the HPO/Governor Module Help Panel? (Y/N)........... ===>

If you press Enter, the next panel will be displayed. If you press PF3, you will return to the HPO Configuration Dialog Selection Menu and the configuration parameters will not be saved.

The fields on the panel are:

TSO Activity
Enter the name of the data set to which Object Manager should log all activity against QMF objects under TSO. If you leave this field blank, no logging will be performed. If the data set exists, it must have DSORG=PS, RECFM=FB, LRECL=80. If it does not exist, a subsequent panel will be displayed, allowing you to allocate it.
TSO SQL Text
Enter the name of the data set to which Object Manager should log SQL text associated with the run of a QMF query under TSO. This logging is conditional, depending on the value of CPU Time Threshold for SQL Text Monitoring specified on this panel. If you leave this field blank, no logging will be performed. If the data set exists, it must have DSORG=PS, RECFM=VB, LRECL=3600, and BLKSIZE=3604. If it does not exist, a subsequent panel will be displayed, allowing you to allocate it.
CICS Activity
Enter the name of the data set to which Object Manager should log all activity against QMF objects under CICS. If you leave this field blank, no logging will be performed. If the data set exists, it must have DSORG=PS, RECFM=FB, LRECL=80. If it does not exist, a subsequent panel will be displayed, allowing you to allocate it.
Note:
CICS object tracking is activated by the specification of the CICS data set names in conjunction with:
  • the QMF HPO resource group assigned to the CICS user
  • the specification of a DB2 subsystem ID for the DB2 location within the assigned resource group (see "Resource group common controls.")
CICS SQL Text
Enter the name of the data set to which Object Manager should log SQL text associated with the run of a QMF query under CICS. This logging is unconditional. If you leave this field blank, no logging will be performed. If the data set exists, it must have DSORG=PS, RECFM=VB, LRECL=3600, and BLKSIZE=3604. If it does not exist, a subsequent panel will be displayed, allowing you to allocate it.
Sort/Merge
Enter the name of the data set to be used during the processing of the TSO and CICS activity log data sets. If a data set was specified for the TSO or CICS activity log, this field must be specified. Otherwise, it is not used. If the data set exists, it must have DSORG=PS, RECFM=FB, LRECL=80. If it does not exist, a subsequent panel will be displayed, allowing you to allocate it.
Activity Archive
Enter the name of the data set in which to archive object activity information from the TSO and CICS activity log data sets after processing them. If a data set was specified for either of the TSO or CICS activity logs, this field must be specified. Otherwise, it is not used. If the data set exists, it must have DSORG=PS, RECFM=FB, LRECL=80. If it does not exist, a subsequent panel will be displayed, allowing you to allocate it.
SQL Text Archive
Enter the name of the data set in which to archive SQL text information from the TSO and CICS SQL text log data sets after processing them. If a data set was specified for either of the TSO or CICS SQL text logs, this field must be specified. Otherwise, it is not used. If the data set exists, it must have DSORG=PS, RECFM=VB, LRECL=3600, and BLKSIZE=3604. If it does not exist, a subsequent panel will be displayed, allowing you to allocate it.
Number of Additional TSO Activity and SQL Text Log Data Sets
Enter the number of additional log data sets to be allocated. In environments that support large numbers of simultaneous QMF users, adding additional log data sets can eliminate file contention by spreading the activity logging I/O across multiple files. Entering 0 results in no additional log data sets. A value of 5, for example, would allocate an additional 5 TSO activity and SQL log data sets. These data sets are created from the base file names you explicitly provide for the TSO activity and SQL text log data sets, and are processed automatically by HPO. A value greater than 0 should be considered on heavily utilized QMF systems.
Activity Log
Enter the DCT name that defines this DB2 subsystem's HPO Activity Log for CICS activity.
SQL Text Log
Enter the DCT name that defines this DB2 subsystem's HPO Activity Log for CICS SQL text.
Monitor File
If Monitor will be used, enter the name of the CLUSTER component of the VSAM data set that it uses. This data set must have been created using the procedures described in "Step 3. Create Monitor VSAM file." If Monitor will not be used, this field should be left blank.
CPU Time Threshold For SQL Text Monitoring
This field is ignored if the HPO Activity Log Data Set Name for TSO SQL Text is left blank. Enter a CPU time threshold value which will determine whether or not SQL text associated with the run of a query will be logged to the TSO SQL text activity log. If the amount of CPU time consumed by a query exceeds this value, its SQL text will be logged. Otherwise, it will not be logged. If you enter 0, all SQL text will be logged. Under CICS, SQL text is always logged.
Enable the HPO/Governor Module Help Panel?
Enter Y to activate the HPO/Governor module help panel whenever the HPO/Governor module cancels a QMF command.


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