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:
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 ***************************** |
This report requires the following input variables:
You can invoke this report by selecting option 6 from the Object Manager Reports Selection Menu.
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.