This report can be run for a specific user to determine which queries are executed and the resources being consumed by those queries. The query executions are sorted in descending order by CPU time consumed. This highlights queries that are most important from a resource consumption standpoint. It can indicate that resource problems are limited to specific queries, or that resource problems occur only when running ad hoc queries. The report contains the actual query text at the time of execution.
The following is an online example of the Resource Consumption Detail for a User report:
RAAMR07T ----------------------------------- LINE 0000000 -- COLUMNS 031 079 Command ===> Scroll ===> PAGE ***************************** TOP OF REPORT ******************************** QMF RESOURCE STATISTICS| FOR TSOID: USER01 | | | QUERY QUERY | OWNER NAME | CPU SECONDS ROWS FETCHED DATE TIME ------ ------- | ------------ ------------ -------- ----- USER01 XDEVTST | 33.31 16245 2099-10-05 11.53 USER01 XDEVTST | 21.95 10334 2099-10-05 10.41 USER01 XENDH | 9.16 988 2099-10-05 13.35 USER01 GGVEEMO | 4.24 2211 2099-10-24 06.13 USER01 XENDH | 2.50 102 2099-10-24 07.10 USER01 GGVEEMO | 0.39 401 2099-10-24 06.15 USER01 GGVEEMO | 0.39 401 2099-10-05 10.57 USER01 GGVEEMO | 0.37 401 2099-10-24 06.16 USER01 QTEST507Q | 0.32 4 2099-10-05 13.04 USER01 QTEST507Q | 0.24 4 2099-10-05 13.06 USER01 QTEST501Q | 0.24 2 2099-10-21 07.48 USER01 QTEST511Q | 0.21 14 2099-10-21 08.09 USER01 QTEST505Q | 0.21 4 2099-10-24 07.08 USER01 QTEST505Q | 0.20 3 2099-10-21 08.00 |
This report requires the following input variable:
You can invoke this report by selecting option 7 from the Object Manager Reports Selection Menu.
Edit the sample JCL member RAAMR07J in QMFHPO.SRAASAMP. See the comments in this JCL member for instructions on what modifications are necessary before submitting the batch job.