DB2 graphic QMF Version 8

Resource consumption detail for a user

This report can be run for a specific user to determine which queries are executed and the resources being consumed by those queries. The query executions are sorted in descending order by CPU time consumed. This highlights queries that are most important from a resource consumption standpoint. It can indicate that resource problems are limited to specific queries, or that resource problems occur only when running ad hoc queries. The report contains the actual query text at the time of execution.

The following is an online example of the Resource Consumption Detail for a User report:

Table 66. Sample Resource Consumption Detail for a User Report
  RAAMR07T ----------------------------------- LINE 0000000 -- COLUMNS 031 079
  Command ===>                                                 Scroll ===> PAGE
***************************** TOP OF REPORT  ********************************
  QMF RESOURCE STATISTICS|
  FOR TSOID: USER01      |
                         |
                         |
  QUERY    QUERY         |
  OWNER    NAME          |  CPU SECONDS    ROWS FETCHED  DATE         TIME
  ------   -------       |  ------------   ------------  --------     -----
  USER01   XDEVTST       |  33.31          16245         2099-10-05   11.53
  USER01   XDEVTST       |  21.95          10334         2099-10-05   10.41
  USER01   XENDH         |  9.16            988          2099-10-05   13.35
  USER01   GGVEEMO       |  4.24            2211         2099-10-24   06.13
  USER01   XENDH         |  2.50             102         2099-10-24   07.10
  USER01   GGVEEMO       |  0.39             401         2099-10-24   06.15
  USER01   GGVEEMO       |  0.39             401         2099-10-05   10.57
  USER01   GGVEEMO       |  0.37             401         2099-10-24   06.16
  USER01   QTEST507Q     |  0.32               4         2099-10-05   13.04
  USER01   QTEST507Q     |  0.24               4         2099-10-05   13.06
  USER01   QTEST501Q     |  0.24               2         2099-10-21   07.48
  USER01   QTEST511Q     |  0.21              14         2099-10-21   08.09
  USER01   QTEST505Q     |  0.21               4         2099-10-24   07.08
  USER01   QTEST505Q     |  0.20               3         2099-10-21   08.00
 

Input variables

This report requires the following input variable:

TSOID
Enter the TSO ID for which you want to obtain resource consumption information.

How to run this report online

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

How to run this report in batch

Edit the sample JCL member RAAMR07J in QMFHPO.SRAASAMP. 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