Performance HDB Reporting
After you have loaded data into an HDB it is then eligible for 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
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
- 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.
Data in a Summary HDB is already summarized by the interval that was used to load the data. This is the value specified in the HDB or, if Time Interval was not specified in the HDB, the value defined in the Template.
You can further summarize the data by specifying a multiple of the interval that was used to load the data. Specify a value in the range 00:00:01 (1 second) to 24:00:00 (24 hours). For example, specify 00:15:00 if you want to summarize transaction activity over 15 minute intervals. 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 Figure 2, the Interval has been changed to 1 hour.
Notes:- If you specify a reporting interval that is equal to or less than the interval that was used to load the data, the report or extract uses the data as-is, without further summarization.
- If you do not specify a reporting interval it defaults to the interval that was used to load the data, unless that value is less than 1 minute, in which case the reporting interval is set to 1 minute.
- 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.
EDIT JCH.SPFTEMP2.CNTL Columns 00001 00072
Command ===> ________________________________________________ Scroll ===> CSR_
****** ***************************** Top of Data ******************************
000001 //CICSPA JOB ,NOTIFY=&SYSUID
000002 //* CICS PA V5R3 HDB REPORT JCL
000003 //CICSPA EXEC PGM=CPAMAIN
000004 //STEPLIB DD DISP=SHR,DSN=CPA.V5R3M0.SCPALINK
000005 //CPAHDBRG DD DISP=SHR,DSN=CICSPROD.CICSPA.HDB.REPOSTRY
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 end 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.
HDB(OUTPUT(HDBR0001),REPORT(CICSP1H))
Enter SUBmit in
the command line to submit the job to run the report. V5R3M0 CICS Performance Analyzer
Historical Database Summary
HDBR0001 Printed at 12:34:56 02/15/2015 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