Performance HDB Reporting

After you have loaded data into an HDB it is then eligible for reporting.

Select option 4 Report from the HDB menu to submit a report request.
Figure 1. Performance HDB Reporting
  File  Options  Help                                                         
------------------------------------------------------------------------------
                                Report HDBs                    Row 1 to 1 of 1
Command ===> ________________________________________________ Scroll ===> CSR_
                                                                              
Select to run report.                                                         
                                                                              
   Name     Type              Description                Changed        ID    
S CICSP1H  SUMMARY  Summary HDB for CICSP1           2004/12/07 09:28 JCH     
********************************* End of list ********************************
                                                                               
 F1=Help    F3=Exit    F7=Backward    F8=Forward    F10=Actions    F12=Cancel  
Select the required HDB from the list to display the Run Report panel, as shown in the following example.
Figure 2. Run Summary HDB Report
  File  Options  Help                                               
------------------------------------------------------------------------
                     Run SUMMARY HDB Report - CICSP1H               
Command ===> ___________________________________________________________
                                                                    
Specify run options then press Enter to continue submit. 
                                                                    
Report Format:                          ----- Report Interval ------
 Report Form  . . ________  +                YYYY/MM/DD  HH:MM:SS.TH
                                        From 2004/12/07  09:00:00.00
                                        To   2004/12/07  16:00:00.00
Reporting Options:                         
 Time Interval . . 01:00:00  (hh:mm:ss)    
 Totals Level  . . 8         (blank or 0-8)
 Precision . . . . 4         (4-6)         
                                           
Enter "/" to select option                                          
/  Edit JCL before submit                                           
                                                                    
HDB contains data from 2004/12/07 09:00 to 2004/12/07 16:00.        
                                                                      
 F1=Help     F3=Exit     F4=Prompt   F6=Resize  F10=Actions F12=Cancel
The options are:
Report Form
Specify a Report Form to tailor the format of the report output. If you do not specify a Form, CICS PA will report all fields in the HDB, in default sequence, up to the maximum 8000 characters.
Report Interval
Specify the reporting time range. You can specify an explicit date, such as 2004/12/07, or a relative date to indicate today (0), yesterday (-1), two days ago (-2), and so on. At the bottom of the display is the time range of data contained in this HDB. If you specify a Report Interval, then it must be within this range otherwise the report request will fail.
Time Interval
Specify an optional Time Interval when reporting Summary HDBs. The default is the Time Interval used to create the data (as defined in the Template). In our example, Template PRODSUM used to create the HDB data specified 15 minutes.

You can specify any interval greater than or equal to the Template Interval. For example, if you are reviewing many days worth of data then you might specify 24:00:00 (24 hours) so that you can view the daily trend. In the example above, the Interval has been changed to 1 hour.

Totals Level
This option applies only to the Summary report. Leave blank if you do not want to include total lines in the report. This generates the NOTOTALS operand.

Specify a number between 1 and 8 to accumulate subtotals for up to 8 sort fields, print the subtotals when the sort field changes, and print a grand total at the end of the report. This generates the TOTALS(n) operand where n is a value between 1 and 8. Default: 8

Specify 0 for no subtotals, but print only the grand total. This generates the TOTALS(0) operand.

Precision
Specify the precision for numeric fields: 4, 5, or 6 decimal places to report up to microseconds. This generates the PRECISION(n) operand for n between 4 and 6. Default: 4

When you have specified your Report options, you are prompted to Press ENTER to proceed with request. This provides a last opportunity to review and change your report request.

If you selected Edit JCL before submit then the Report HDB JCL is displayed in an edit session.
Figure 3. Edit JCL for Summary HDB report
EDIT       JCH.SPFTEMP2.CNTL                               Columns 00001 00072 
Command ===> ________________________________________________ Scroll ===> CSR_ 
****** ***************************** Top of Data ******************************
000001 //CICSPA  JOB ,NOTIFY=&SYSUID                                           
000002 //*  CICS PA V3R2 HDB REPORT JCL                                        
000003 //CICSPA   EXEC PGM=CPAMAIN                                             
000004 //STEPLIB  DD DISP=SHR,DSN=CPA.V3R2M0.SCPALINK                          
000005 //CPAHDBRG DD DISP=SHR,DSN=CICSPROD.CICSPA.HDB.REGISTER                 
000006 //SYSPRINT DD SYSOUT=*                                                  
000007 //* Command Input                                                       
000008 //SYSIN DD *                                                            
000009 * HDB=CICSP1H                                                           
000010 * Description=Summary HDB for CICSP1                                    
000011          CICSPA SMFSTART(2004/12/07,09:00:00.00),                       
000012                  SMFSTOP(2004/12/07,16:00:00.00)                        
000013          CICSPA NOAPPLID,                                               
000014                 LINECNT(60),PRECISION(4),                               
000015                 FORMAT(':','/'),                                        
000016             HDB(OUTPUT(HDBR0001),REPORT(CICSP1H),                       
000017                 INTERVAL(01:00:00),NOTOTALS)                            
000018 /*                                                                      
000019 //* HDB Container Data Sets. HDB Report processing does not require     
000020 //* these data sets to be included in the JCL as they are dynamically   
000021 //* allocated when required. They are included:                         
000022 //* 1) for your reference                                               
000023 //* 2) to ensure that all required data sets are cataloged              
000024 //* 3) to allow DFHSM to recall required data sets up front             
000025 //HDB00001 DD DISP=SHR,DSN=JCH.CICSP1H.D03219.T092846.HDB               
****** **************************** Bottom of Data ****************************

The HDB container data sets are listed at the bottom of the JCL. They are not required here because the CICS PA batch reporting utility will dynamically allocate the data sets when they are required. CICS PA adds the data sets into the JCL primarily for the purpose of DFHSM recall, if required. It is more efficient to recall data sets in the JCL (where job initiation can recall migrated data sets en masse) rather than one at a time when dynamically allocated.

The command deck specifies operands to report against HDB CICSP1H:
HDB(OUTPUT(HDBR0001),REPORT(CICSP1H))
Enter SUBmit in the command line to submit the job to run the report.
Successful completion of the Report request will generate an HDB Summary report.
Figure 4. HDB Summary report
 V3R2M0                                                  CICS Performance Analyzer
                                                        Historical Database Summary
 
HDBR0001 Printed at 12:03:45  3/15/2011     Data from 09:00:00 12/07/2004 to 16:00:00 12/07/2004                       Page  1
                                                                                                                                   
                                                   Avg      Avg      Avg      Avg      Avg      Avg      Avg      Avg      Avg     
 Start            MVS  APPLID   Tran    Tasks Response Dispatch User CPU  Suspend DispWait  FC Wait  IR Wait SC24UHWM SC31UHWM     
 Interval                                         Time     Time     Time     Time     Time     Time     Time                       
 2004/12/07 09:00 MVS1 CICSP1   ABRA        1    .2729    .0009    .0006    .2720    .0000    .0000    .2719        0        0     
 2004/12/07 09:00 MVS1 CICSP1   ASIX        2    .2184    .0009    .0006    .2175    .0000    .0000    .2175        0        0     
 2004/12/07 09:00 MVS1 CICSP1   ATRA        1   1.6067    .0008    .0005   1.6058    .0000    .0000   1.6057        0        0     
 2004/12/07 09:00 MVS1 CICSP1   BLIX        1    .0845    .0008    .0005    .0836    .0000    .0000    .0835        0        0     
 2004/12/07 09:00 MVS1 CICSP1   CRVI        1    .0004    .0004    .0000    .0000    .0000    .0000    .0000        0        0     
 2004/12/07 09:00 MVS1 CICSP1   CSMI        2    .0107    .0006    .0004    .0101    .0000    .0000    .0101        0        0     
 2004/12/07 09:00 MVS1 CICSP1   DEBT        1    .0038    .0006    .0004    .0032    .0000    .0000    .0031        0        0     
 2004/12/07 09:00 MVS1 CICSP1   OPIC        1    .0236    .0008    .0006    .0227    .0000    .0000    .0227        0        0     
 2004/12/07 09:00 MVS1 CICSP1   RESU        1    .0341    .0009    .0006    .0332    .0000    .0000    .0332        0        0     
 2004/12/07 09:00 MVS1 CICSP1   RGYM        1    .0056    .0010    .0007    .0046    .0000    .0000    .0045        0        0     
 2004/12/07 09:00 MVS1 CICSP1   T050        2    .0296    .0009    .0006    .0288    .0000    .0000    .0286        0        0     
 2004/12/07 09:00 MVS1 CICSP1   T096        1    .0398    .0012    .0005    .0386    .0001    .0000    .0385        0        0     
 2004/12/07 09:00 MVS1 CICSP1   XYLO        1    .0010    .0009    .0001    .0001    .0000    .0000    .0000    11600    16368