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