DB2 graphic QMF Version 8

Resource usage summary for a time period

This report shows which users are most actively using QMF and consuming the most resources during a specific period of time. Information on the report can be used for chargeback purpose, trend analysis, or problem identification. The following is an online example of the Resource Usage Summary for a Time Period report:

Table 68. Sample Resource Usage Summary for a Time Period Report
  RAAMR09T ----------------------------------- LINE 0000000 -- COLUMNS 001 080
  Command ===>                                                  Scroll ===>PAGE
****************************** TOP OF REPORT  *******************************
                           QMF RESOURCE USAGE BY USER
                       FOR PERIOD 2099-10-01 TO 2099-10-31
 
 
  TSOID     SQLID     RUN COUNT    TOTAL CPU TIME      TOTAL ROW COUNT
  --------  --------  -----------  ------------------  ------------------
  DBPUSR    DBPUSR             36              175.75               92148
  USER01    USER01             32               75.30               31329
  XND1XY    XND1XY              9                1.44                  51
  TSO01P    TSO01P             12                1.29                  27
 
***************************** BOTTOM OF REPORT ******************************
 

Input variables

This report requires the following input variables:

Begin Date
Enter the beginning date (in YYYY-MM-DD format) for which you want to obtain resource usage information.
End Date
Enter the ending date (in YYYY-MM-DD format) for which you want to obtain resource usage information.

How to run this report online

You can invoke this report by selecting option 9 from the Object Manager Reports Selection Menu.

How to run this report in batch

Edit the sample JCL member RAAMR09J in QMFHPO.SRAASAMP. See this JCL for details on how to modify and run this report. See the comments in this JCL member for instructions on what modifications are necessary before submitting the batch job.


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