DB2 graphic QMF Version 8

Performance summary for a query

This report shows which users most often execute a specific query and the CPU time that it consumes. It can be used once a problem query is identified to determine which users are most frequently executing that query.

The following is an online example of the Performance Summary for a Query report.

Table 64. Sample Performance Summary for a Query Report
RAAMR05T ------------------------------------- LINE 0000000 -- COLUMNS 001 080
Command ===>                                                  Scroll ===> PAGE
******************************** TOP OF REPORT ******************************
                          QMF RESOURCE USAGE BY USER
                           FOR QUERY USER01.XDEVTST
 
 
TSOID     SQLID     RUN COUNT    TOTAL CPU TIME
--------  --------  -----------  ------------------
USER01    USER01              2               55.26
 
****************************** BOTTOM OF REPORT *****************************

Input variables

This report requires the following input variables:

Query Owner
Enter the owner of the query for which you want to obtain performance information.
Query Name
Enter the name of the query for which you want to obtain performance information.

How to run this report online

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

How to run this report in batch

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