DB2 graphic QMF Version 8

Performance summary based on maximum CPU

This report shows performance data for queries including their maximum CPU time consumed and number of times run. It is sorted in descending order to highlight those queries with the largest CPU consumption. Queries that are frequently run and have high CPU time consumption are the best candidates for converting to static SQL programs with Program Generator because they present the greatest opportunities for cost savings.

The following is an online example of the Performance Summary Based on Maximum CPU report:

Table 62. Sample Performance Summary Based on Maximum CPU Report
  RAAMR03T ---------------------------- LINE 0000000 -- COLUMNS 031 079
  Command ===>                                       Scroll ===> PAGE
**************************** TOP OF REPORT ****************************
  QMF QUERIES                 |
  MAXIMUM CPU AND RUN COUNT   |
  SORTED BY CPU SECONDS (DESC)|
                              |
  QUERY     QUERY             |      MAXIMUM       NUMBER OF   DATE
  OWNER     NAME              |   CPU (SECONDS)   TIMES RUN  FIRST RUN
  --------  ----------------- |   -------------   ---------  ---------
  DBPUSR    Q2Q11             |   37.28           14        2099-10-05
  USER01    RUNAWAY           |   33.31            2        2099-10-05
  USER01    GGVDEEO           |    4.24            5        2099-10-05
  USER01    QTEST506Q         |    0.34            4        2099-10-12
  USER01    QTEST504Q         |    0.32            8        2099-10-11
  USER01    QTEST507Q         |    0.32            2        2099-10-05
  TSOTEST1  XAAAR02Q          |    0.30            1        2099-10-19
  USER01    XAABR06Q          |    0.27            3        2099-10-20
  USER01    QTEST501Q         |    0.24            1        2099-10-21
  USER01    QTEST505Q         |    0.21            2        2099-10-21
  USER01    QTEST511Q         |    0.21            1        2099-10-21
  USER01    QTEST502Q         |    0.19            2        2099-10-21
 

Note:
More information on a specific query's performance can be gathered from the Performance Detail For a Query report and the Resource Consumption Detail For a User reports, which are described below.

Input variables

This report requires no input variables.

How to run this report online

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

How to run this report in batch

Edit the sample JCL member RAAMR03J 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