This report shows performance data for queries including their maximum CPU time consumed and number of times run. It is sorted in descending order to highlight those queries with the largest CPU consumption. Queries that are frequently run and have high CPU time consumption are the best candidates for converting to static SQL programs with Program Generator because they present the greatest opportunities for cost savings.
The following is an online example of the Performance Summary Based on Maximum CPU report:
RAAMR03T ---------------------------- LINE 0000000 -- COLUMNS 031 079 Command ===> Scroll ===> PAGE **************************** TOP OF REPORT **************************** QMF QUERIES | MAXIMUM CPU AND RUN COUNT | SORTED BY CPU SECONDS (DESC)| | QUERY QUERY | MAXIMUM NUMBER OF DATE OWNER NAME | CPU (SECONDS) TIMES RUN FIRST RUN -------- ----------------- | ------------- --------- --------- DBPUSR Q2Q11 | 37.28 14 2099-10-05 USER01 RUNAWAY | 33.31 2 2099-10-05 USER01 GGVDEEO | 4.24 5 2099-10-05 USER01 QTEST506Q | 0.34 4 2099-10-12 USER01 QTEST504Q | 0.32 8 2099-10-11 USER01 QTEST507Q | 0.32 2 2099-10-05 TSOTEST1 XAAAR02Q | 0.30 1 2099-10-19 USER01 XAABR06Q | 0.27 3 2099-10-20 USER01 QTEST501Q | 0.24 1 2099-10-21 USER01 QTEST505Q | 0.21 2 2099-10-21 USER01 QTEST511Q | 0.21 1 2099-10-21 USER01 QTEST502Q | 0.19 2 2099-10-21 |
This report requires no input variables.
You can invoke this report by selecting option 3 from the Object Manager Reports Selection Menu.
Edit the sample JCL member RAAMR03J in QMFHPO.SRAASAMP. See the comments in this JCL member for instructions on what modifications are necessary before submitting the batch job.