Defining a report set for daily monitoring
One way to define a report set for daily monitoring is to use form-based reporting and take advantage of the many sample report forms supplied with CICS PA.
To set up a selection of report forms:
- From the Primary Option Menu, select option 3 Report Forms.
- The Report Forms list is displayed showing the names of report
forms that you previously defined.
File Confirm Samples Options Help ------------------------------------------------------------------------------ Report Forms Command ===> SAMPLES_________________________________________ Scroll ===> CSR_ Report Forms Data Set . . . xxxx.CICSPA.FORM / Name Type Description Changed ID _ HOURMON SUMMARY Transaction monitoring by hour 2010/10/10 23:18 SEC ******************************* End of list *********************************
- To select a set of sample forms to add to your Report Forms data set, enter the SAMPLES command or select Report Forms panel. in the action bar of the
The Sample Form Search panel opens. There are over 200 sample forms. This panel allows you to specify selection criteria to reduce the list to a manageable subset of matching forms.
For now, press Enter. The full set of available samples is listed in a window which you can resize to a full screen by pressing RESIZE (F6).
- Use the FIND command
or scroll up/down (F7/F8) to find the sample report forms that meet
your requirements. For this exercise, we will use the following set
of forms as an example of a daily monitoring report set:
- BADCPU
- LISTX Form: Top 20 Worst CPU Times
- BADRESP
- LISTX Form: Top 20 Worst Response Times
- CPULST
- LIST Form: Transaction CPU Analysis
- CPUSUM
- SUMMARY Form: Transaction CPU Analysis
- RESPRNGP
- SUMMARY Form: Response Time Distribution (%)
Sample Report Forms Row 8 to 44 of 249 Command ===> _____________________________ Scroll ===> CSR Select one or more Sample Report Forms then press EXIT. Name Type Description _ BADCHMDS LISTX Top 20 Worst Change TCB Modes S BADCPU LISTX Top 20 Worst CPU Times _ BADDB2R LISTX Top 20 Worst DB2 Requests (V5) _ BADDB2RQ LISTX Top 20 Worst DB2 Requests _ BADFCRQ LISTX Top 20 Worst File Requests S BADRESP LISTX Top 20 Worst Response Times _ BADRMI LISTX Top 20 Worst CICS RMI Times _ BADRMIRQ LISTX Top 20 Worst CICS RMI Requests _ BADSUSP LISTX Top 20 Worst Suspend Times _ BADTDRQ LISTX Top 20 Worst Tdqueue Requests
_ BADTSAWT LISTX Top 20 Worst Auxiliary TS Waits
_ BADTSRQ LISTX Top 20 Worst Tsqueue Requests
_ BADTSRQ5 LISTX Top 20 Worst Tsqueue Requests
_ BADTSSWT LISTX Top 20 Worst Shared TS Waits
_ BADWBRQ LISTX Top 20 Worst CICS Web Requests _ BADWMQRQ LISTX Top 20 Worst WebSphere MQ Reqsts _ BTSACLST LIST CICS BTS Activity - Overview _ BTSRQLST LIST CICS BTS Request Activity _ BTSRQSUM SUMMARY CICS BTS Request Activity _ CCLST LIST Channel Container Activity _ CCSUM SUMMARY Channel Container Activity _ CEC5LST LIST Transaction CEC Analysis (V5) _ CHMDSRNG SUMMARY Change TCB Mode Distribution _ COMMWLST LIST Transaction Comms Wait Analysis _ COMMWSUM SUMMARY Transaction Comms Wait Analysis _ CPULEXTR LIST CPU Analysis and Extract S CPULST LIST Transaction CPU Analysis _ CPULST1 LIST Transaction CPU Analysis (1) _ CPUSESUM SUMMARY Transaction CPU Analysis (V5) _ CPUSEXTR SUMMARY CPU Analysis and Extract _ CPUSPLST LIST Transaction CPU Analysis (V5) _ CPUSPSM1 SUMMARY Transaction CPU Analysis (V5) _ CPUSPSUM SUMMARY Transaction CPU Analysis (V5) S CPUSUM SUMMARY Transaction CPU Analysis _ CPUSUM1 SUMMARY Transaction CPU Analysis (1) F1=Help F3=Exit F5=Rfind F6=Resize F12=Cancel
- Enter line action S to select relevant forms. To select all forms, enter S * on the command line. When the selection is complete, press Exit (F3).
- The selected sample report forms are saved to the Report Forms data set and are now available for report processing. Exit to return to the Primary Option Menu.
- To use the report forms in your report requests, select option 2 Report Sets from the Primary Option Menu.
- There are many ways to proceed from here. We will work through one of them.
- From the list of report sets, select REPORTS1, the report set that we worked with earlier.
- From the Report Set edit tree, select the Performance List report.
- Because a List report has already been defined in this report set, the list of reports is displayed.
- Enter line action R to repeat a row.
- Enter line action D to delete unwanted reports. Alternatively, enter line action X to retain it in the list but exclude it from reporting.
- In the new row, change the Output to a unique DDname and specify
the report form name. You can press Prompt (F4) from the Form
field to select from a list of available LIST forms. Exit to return to the Report Set edit panel.
File Filter Edit Systems Options Help ------------------------------------------------------------------------------ REPORTS1 - Performance List Reports Row 1 from 2 Command ===> ________________________________________________ Scroll ===> PAGE ---- System Selection ---- Selection / Exc APPLID + Image + Group + Output Form + Alert + Criteria _ * ________ ________ ________ LIST0001 ________ ________ NO _ ________ ________ ________ LIST0002 CPULST__ ________ NO ******************************* Bottom of data ********************************
- Now select the Performance List Extended report.
- In the Form field, specify the name of the first of our LISTX
report forms. You can press Prompt (F4) from the Form field
to select from a list of available LISTX forms.
File Systems Options Help ------------------------------------------------------------------------------ REPORTS1 - Performance List Extended Report Command ===> _________________________________________________________________ System Selection: Report Output: APPLID . . ________ + DDname . . . . . . . . . LSTX0001 Image . . ________ + Print Lines per Page . . ___ (1-255) Group . . ________ + Report Format: Form . . . BADCPU__ + Title . . ________________________________________________________________ ________________________________________________________________ Selection Criteria: _ Performance
For an explanation of each report option, tab to the field and press Help (F1).
- Exit to save your new report specification. The list of reports shows one report.
- Now to request a second report of the same type, use line action R to
repeat the first row. In the second row, change the Output field to
a unique DDname, and specify the name of the second LISTX report form
or press Prompt (F4) from the Form field to select from a list
of available LISTX forms.
File Filter Edit Systems Options Help ------------------------------------------------------------------------------ REPORTS1 - Performance List Extended Reports Row 1 from 2 Command ===> ________________________________________________ Scroll ===> PAGE ---- System Selection ---- Selection / Exc APPLID + Image + Group + Output Form + Criteria _ ________ ________ ________ LSTX0001 BADCPU__ NO _ ________ ________ ________ LSTX0002 BADRESP_ NO ******************************* Bottom of data ********************************
Note: When you repeat an existing report definition, the new report inherits the reporting options, including selection criteria, from the original report definition. To change the reporting options, you must select the new report definition and make the required changes. - Exit to save the specification of both reports and return to the Report Set edit panel.
- Now select the Performance Summary report. If you previously defined Performance Summary reports in this report set, the list of reports is displayed. Enter line action S to select a report.
- The
Summary report edit panel is displayed. To assign the first of our
SUMMARY report forms to the report, enter the report form name CPUSUM
or press Prompt (F4) from the Report Form field to select from
the list of SUMMARY forms.
File Systems Options Help ------------------------------------------------------------------------------ REPORTS1 - Performance Summary Report Command ===> _________________________________________________________________ System Selection: Report Output: APPLID . . ________ + DDname . . . . . . . . . SUMM0001 Image . . ________ + Print Lines per Page . . ___ (1-255) Group . . ________ + Report Focus: Report by time interval: Form . . . CPUSUM__ + Interval . . . 00:01:00 (hh:mm:ss) Alert . . ________ + Override Form ________ + _ Eligible transactions only Timestamp . . . ________ + Reporting Options: Totals Level . . 8 (blank or 0-8) Title . . ________________________________________________________________ ________________________________________________________________ Selection Criteria: Execution Option: _ Performance / Use External Sort Repository . . :
The default values for the report options might be adequate for your purposes, or you might choose to tailor the report. Some interesting options are:- Interval
- Specifies
a time interval when the report summarizes transaction activity over
time. The interval is in the range 1 second to 24 hours in the format hh:mm:ss for
hours, minutes, and seconds.
This operand applies only when the report or extract is sorted by transaction start or stop time. That is, when START, STOP, or OSTART is a summarization key field at the top of the report form. CICS PA accumulates data for each interval in the report period and writes a report line or extract record for each interval. The default interval is 00:01:00 (1 minute).
- Override Form, Timestamp
- For reporting by time interval, you can PREFIX, APPEND, or REPLACE the report form key fields with a timestamp field, either START, STOP, or OSTART. The Form itself is not affected.
- Alert, Eligible transactions only
- The name of a Performance Alert definition which specifies resource and threshold criteria for reporting non-compliant transactions. Eligible transactions are those that match the specified resource criteria. Alert definitions are maintained in the Repository.
- Totals Level
- Indicates the level of totals to include in the report. Leave blank for no totals. Specify 0 (zero) for grand totals only. Specify 1 to 8 for sub-totals to that level (limited by the number of key fields in the report form or Alert Definition) plus grand totals. The default is 8 (the maximum number of key fields).
- Selection Criteria
- For filtering the input data to restrict reporting to values of interest. This specifies what to include or exclude from the report or extract based on field values.
Exit when your report specification is complete.
- The list of Summary reports is displayed.
- As before, to request a second report of the same type, use line
action R to repeat the first row. In the second row, change
the Output field to a unique DDname and specify the name of the second
SUMMARY report form. Exit to return to the Report Set edit panel.
File Filter Edit Systems Options Help ------------------------------------------------------------------------------ REPORTS1 - Performance Summary Reports Row 1 from 2 Command ===> ________________________________________________ Scroll ===> PAGE ---- System Selection ---- Selection / Exc APPLID + Image + Group + Output Form + Alert + Criteria _ ________ ________ ________ SUMM0001 CPUSUM__ ________ NO _ ________ ________ ________ SUMM0002 RESPRNGP ________ NO ******************************* Bottom of data ********************************
- If Record Selection extract or any other reports not relevant to daily monitoring are showing Active (Yes), enter line action D to deactivate so they will not be included when the report set is run.
- Change the description to something appropriate for daily monitoring.
- To save changes in a second report set without altering the first, enter SAVEAS on the command line. Enter the new name when prompted (for example, DAILYCHK) and press Enter to save.
- When the message Member DAILYCHK saved is displayed, you can Cancel (F12) to discard changes to the first report set.
- The DAILYCHK report set is now ready to run.
File Systems Confirm Options Help ------------------------------------------------------------------------------ Report Sets Row 1 to 2 of 2 Command ===> ________________________________________________ Scroll ===> PAGE Report Sets Data Set . . : xxxx.CICSPA.RSET / Name Description Changed ID RUN DAILYCHK Daily monitoring form-based rpts 2010/10/11 17:40 SEC ___ REPORTS1 Demonstration Report Set 2010/10/11 17:14 SEC ******************************* Bottom of data ********************************
- Enter the RUN command as a line action to run the report set from the Report Sets list. Alternatively, enter line action S to edit the report set, then enter RUN on the command line of the Report Set tree panel.
- When the Run Report Set panel is displayed, ensure that you select the option Edit JCL before submit. Press Enter to proceed.
- When the generated JCL is displayed in an ISPF edit session, you can use the CREATE command to save the JCL in an automated job scheduler JCL library to run in the future.
- To submit the job from ISPF edit, enter SUB on the command line.
- Exit to return.
- To check the progress of the job and view the output, split the screen (F2) then use ISPF option 3.8 Outlist Utility or SDSF.
- On the SDSF status display, enter the ? action
character in the NP column.
SDSF STATUS DISPLAY ALL CLASSES COMMAND INPUT ===> SCROLL ===> CSR NP JOBNAME JobID Owner Max-RC Prty Queue C Pos SAff ASys Status PrtDest SecLabel TGNum ? SECQ JOB34420 SEC CC 0004 1 PRINT A 4633 LOCAL 26
- Then enter the S action
character to select the report output identified by their DDnames.
SDSF JOB DATA SET DISPLAY - JOB SECQ (JOB34420) LINE 1-10 (10) COMMAND INPUT ===> SCROLL ===> CSR NP DDNAME StepName ProcStep DsID Owner C Dest Rec-Cnt Page-Cnt Byte-Cnt CC Rmt Node 0-Grp-N SecLabel PrMod JESMSGLG JES2 2 SEC X LOCAL 31 2,331 1 1 1 LINE JESJCL JES2 3 SEC X LOCAL 30 1,547 1 1 1 LINE JESYSMSG JES2 4 SEC X LOCAL 97 6,429 1 1 1 LINE SYSPRINT CICSPA 102 SEC X LOCAL 192 15,304 1 1 1 LINE SYSOUT CICSPA 103 SEC X LOCAL 140 9,322 1 1 1 LINE S LIST0002 CICSPA 104 SEC X LOCAL 24,943 2M 1 1 1 LINE S LSTX0001 CICSPA 105 SEC X LOCAL 263 32,730 1 1 1 LINE S LSTX0002 CICSPA 106 SEC X LOCAL 263 32,755 1 1 1 LINE S SUMM0001 CICSPA 107 SEC X LOCAL 28 3,328 1 1 1 LINE S SUMM0002 CICSPA 108 SEC X LOCAL 3,066 321,185 1 1 1 LINE
- Here is an example of the Performance Summary report output with
DDname SUMM0002. It used sample report form RESPRNGP to show the percentage
distribution minute-by-minute of transaction response times.
Performance Summary SUMM0002 Printed at 0:56:18 8/15/2015 Data from 15:30:33 7/29/2015 to 23:59:52 7/29/2015 Page 52 Transaction Response Time Distribution Summary (Percentage) by Time-of-Day <0.1 0.1-0.25 0.25-0.5 0.5-0.75 0.75-1.0 1.0-1.5 1.5-2.0 2.0-10.0 >=10.0 Max Avg Stop Tran #Tasks Response Response Response Response Response Response Response Response Response Response Response Interval Time Time Time Time Time Time Time Time Time Time Time . . . 23:57:00 CCXD 1 100.00 .00 .00 .00 .00 .00 .00 .00 .00 .0489 .0489 23:57:00 CCXF 1 100.00 .00 .00 .00 .00 .00 .00 .00 .00 .0240 .0240 23:57:00 WMTD 24 100.00 .00 .00 .00 .00 .00 .00 .00 .00 .0072 .0025 23:57:00 26 100.00 .00 .00 .00 .00 .00 .00 .00 .00 .0489 .0051 23:58:00 WMTD 22 100.00 .00 .00 .00 .00 .00 .00 .00 .00 .0031 .0017 23:58:00 22 100.00 .00 .00 .00 .00 .00 .00 .00 .00 .0031 .0017 23:59:00 CCXD 1 100.00 .00 .00 .00 .00 .00 .00 .00 .00 .0182 .0182 23:59:00 CCXF 1 100.00 .00 .00 .00 .00 .00 .00 .00 .00 .0156 .0156 23:59:00 CSPM 1 .00 .00 .00 .00 .00 .00 .00 .00 100.00 1887.436 1887.436 23:59:00 WMTD 13 100.00 .00 .00 .00 .00 .00 .00 .00 .00 .0030 .0019 23:59:00 16 93.75 .00 .00 .00 .00 .00 .00 .00 6.25 1887.436 117.9684 Total 15127 97.92 .19 .28 .11 .03 .30 .00 .01 1.16 1887.676 21.4308