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 setup a selection of Report Forms:
  1. From the Primary Option Menu, select option 3 Report Forms.
  2. 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 *********************************
     
  3. To select a set of sample Report Forms, enter the SAMPLES command or place the cursor on the Samples action bar option and press Enter. Available samples are listed in a window which you can resize to a full screen by pressing RESIZE (F6).
  4. 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 1 to 36 of 174
    Command ===> _____________________________ Scroll ===> PAGE                   
                                                                                  
    Select one or more Sample Report Forms then press EXIT.                       
                                                                                  
       Name      Type     Description                                             
    _  ABNDLST   LIST     Transaction Abend List                                  
    _  ABNDSUM   SUMMARY  Transaction Abend Summary                               
    _  ACCTSUM   SUMMARY  Accounting Summary HDB Extract                          
    _  ASSCLST   LIST     Association Data Analysis (V4)                          
    _  BADCHMDS  LISTX    Top 20 Worst Change TCB Modes                           
    S  BADCPU    LISTX    Top 20 Worst CPU Times                                  
    _  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                           
    _  BADTSRQ   LISTX    Top 20 Worst Tsqueue Requests                           
    _  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                              
    _  CC3LST    LIST     Channel Container Activity (V3)                         
    _  CC3SUM    SUMMARY  Channel Container Activity (V3)                         
    _  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)                            
    _  CPUSEXTR  SUMMARY  CPU Analysis and Extract                                
    S  CPUSUM    SUMMARY  Transaction CPU Analysis                                
    _  CPUSUM1   SUMMARY  Transaction CPU Analysis (1)                            
    _  CPU3LEXT  LIST     CPU Analysis and Extract (V3)                           
    _  CPU3SEXT  SUMMARY  CPU Analysis and Extract (V3)                           
     F1=Help      F3=Exit      F5=Rfind     F6=Resize   F12=Cancel                
  5. 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).
  6. 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.
  7. To use the Report Forms in your report requests, select option 2 Report Sets from the Primary Option Menu.
  8. There are many ways to proceed from here. We will work through one of them.
  9. From the list of Report Sets, select REPORTS1, the Report Set that we worked with earlier.
  10. From the Report Set edit tree, select the Performance List report.
  11. Since a List report has already been defined in this Report Set, the list of reports is displayed.
  12. Enter line action R to repeat a row.
  13. Enter line action D to delete unwanted reports. Alternatively, enter line action X to retain it in the list but exclude it from reporting.
  14. 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.
  15.   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 ******************************** 
    Exit to return to the Report Set edit panel.
  16. Now select the Performance List Extended report.
  17. 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 the report options, tab to the field of interest and press Help (F1).

  18. Exit to save your new report specification. The list of reports shows one report.
  19. 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 +    Alert +   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.
  20. Exit to save the specification of both reports and return to the Report Set edit panel.
  21. 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.
  22. 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.

  23. The list of Summary reports is displayed.
  24. 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.
      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 ******************************** 
    Exit to return to the Report Set edit panel.
  25. 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.
  26. Change the Report Set description to something appropriate for daily monitoring.
  27. 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.
  28. When the message Member DAILYCHK saved is displayed, you can Cancel (F12) to discard changes to the first Report Set.
  29. 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 ********************************
  30. 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.
  31. When the Run Report Set panel is displayed, ensure that you select the option Edit JCL before submit. Press Enter to proceed.
  32. 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.
  33. To submit the job from ISPF edit, enter SUB on the command line.
  34. Exit to return.
  35. 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.
  36. 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    
  37. 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 
  38. 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 10/15/2010     Data from 15:30:33  9/29/2010 to 23:59:52  9/29/2010                       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 
                                                                                                                                 

Information Information

Feedback


Timestamp icon Last updated: Saturday, 8 February 2014


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic///getting-started/cpags588.htm