DB2 graphic QMF Version 8

Performance detail for a query

This report shows detail statistics for each execution of a query. It provides performance information such as CPU time consumed and rows fetched for each execution and an average CPU time consumed in seconds for all executions.

The following is an online example of the Performance Detail for a Query report:

Table 65. Sample Performance Detail for a Query Report
  RAAMR06T ----------------------------------- LINE 0000000 -- COLUMNS 001 080
  Command ===>                                                  Scroll ===> PAGE
 
****************************** TOP OF REPORT ********************************
  QMF RESOURCE STATISTICS
  FOR QUERY USER01.XDEVTST
 
 
  TSOID    SQLID   CPU SECONDS   ROWS FETCHED   DATE        TIME       QUERY T
  -------  ------  ------------  -------------- ------      -----      -------
  USER01   USER01         33.31           16245 2099-10-05  11.53.41   SELECT
  USER01   USER01         21.95           10334 2099-10-05  10.41.04   SELECT
 
  AVERAGE CPU TIME FOR USER01.XDEVTST IS 27.63
 
****************************** 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 6 from the Object Manager Reports Selection Menu.

How to run this report in batch

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