After you have loaded data into an HDB it is then eligible for extract to CSV data sets.
File Options Help
------------------------------------------------------------------------------
Extract 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
Run SUMMARY HDB Extract - CICSP1H
Command ===> ___________________________________________________________
Specify Extract request options then press Enter to continue submit.
----- Report Interval ------ HDB contains data
YYYY/MM/DD HH:MM:SS.TH in the range:
From 2004/12/15 ___________ 2004/11/17 05:17 Extract Recap:
To 2004/12/16 ___________ 2005/01/17 21:31 DDname . . . HXTS0001
Output Data Set:
Data Set Name . . HDB.EXTRACT___________________________________
Disposition . . . 1 1. OLD 2. MOD (If cataloged)
Extract Format: Enter "/" to select option
Form . . . . . . ________ + / Include Field Labels
Delimiter . . . . ; _ Numeric Fields in Float format
Processing Options: Enter "/" to select option
Time Interval . . 01:00:00 (hh:mm:ss) / Edit JCL before submit
Precision . . . . 4 (4-6)
F1=Help F3=Exit F4=Prompt F6=Resize F12=Cancel
CICS PA assigns a default DDname HXTS0001.
This option generates the OUTPUT(ddname) operand.
If CICS PA is to create the data set at run time, the default allocation attributes specified on the Reporting Allocation Settings panel are used in generating the JCL. If the data set is already cataloged, then CICS PA will use DISP=OLD or DISP=MOD according to your request to overwrite or append to the existing data set.
CICS PA generates the DDNAME(ddname) operand and assigns a default DDname HDBX0001.
Select option 1 - OLD to overwrite the data set contents with the new extract data.
Select option 2 - MOD to append the new extract data.
Leave blank if you do not want a field labels record written to the extract data set. This generates the NOLABELS operand.
If you do not select this option, the numeric fields are written in a mixture of integer, real and exponential using character digits. This is the default and is suitable when importing the extract data into a PC spreadsheet tool. This generates the NOFLOAT operand.
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 panel in this topic, the Interval has been changed to 1 hour.
This option generates the PRECISION(n) global operand.
When you have specified your Extract options, you are prompted to Press ENTER to proceed with request. This provides a last opportunity to review and change your request details.
EDIT userid.SPFTEMP2.CNTL Columns 00001 00072
Command ===> ________________________________________________ Scroll ===> CSR_
****** ***************************** Top of Data ******************************
000001 //CICSPA JOB ,NOTIFY=&SYSUID
000002 //* CICS PA V5R1 HDB EXTRACT JCL
000003 //CICSPA EXEC PGM=CPAMAIN
000004 //STEPLIB DD DISP=SHR,DSN=CPA.V5R1M0.SCPALINK
000005 //CPAHDBRG DD DISP=SHR,DSN=CICSPROD.CICSPA.XYX.REPOSTRY
000006 //SYSPRINT DD SYSOUT=*
000007//HDBX0001 DD DSN=userid.HDB.EXTRACT,
000008// DISP=(OLD)
000009 //* Command Input
000010 //SYSIN DD *
000011 * HDB=CICSP1H
000012 * Description=Summary HDB for CICSP1H
000013 CICSPA SMFSTART(2004/12/15,00:00:00.00),
000014 SMFSTOP(2004/12/16,00:00:00.00)
000015 CICSPA NOAPPLID,
000016 LINECNT(60),
000017 FORMAT(':','/'),
000018 PRECISION(4),
000019 HDB(DDNAME(HDBX0001),EXTRACT(CICSP1H),
000020 OUTPUT(HXTS0001),LABELS,DELIMIT(';'),NOFLOAT,
000021 INTERVAL(01:00:00))
000022 /*
000023 //* HDB Container Data Sets. HDB Report processing does not require
000024 //* these data sets to be included in the JCL as they are dynamically
000025 //* allocated when required. They are included:
000026 //* 1) for your reference
000027 //* 2) to ensure that all required data sets are cataloged
000028 //* 3) to allow DFHSM to recall required data sets up front
000029 //HDB00001 DD DISP=SHR,DSN=userid.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 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(DDNAME(HDBX0001),EXTRACT(CICSP1H),OUTPUT(HXTS0001),...)
Enter SUBmit in
the command line to submit the job to run the report. V5R1M0 CICS Performance Analyzer
Historical Database Summary
HXTS0001 Printed at 12:03:45 04/17/2013 Data from 15:00:00 12/15/2004 to 00:00:00 12/16/2004 Page 1
HDBX0001 Extract has completed successfully
Data Set Name . . . . userid.HDB.EXTRACT
Record count . . . . 788
Start Date;Start Time;MVS;APPLID;Tran;#Tasks;Response Time Avg;Dispatch Time Avg;User CPU Time Avg;Suspend Time
2004/12/15 15:00:00;MV2C ;IYK3ZAC1;CSHQ ; 1;55155.62; .2103; .0212;55155.41; .0331; .0001;
2004/12/15 15:00:00;MV2C ;IYK3ZAC1;CSNC ; 1;55159.06; .3379; .0041;55158.72; .0356; .0001;
2004/12/15 15:00:00;MV2C ;IYK3ZAC1;CSNE ; 1;55153.97; .0881; .0060;55153.88; .0042; .0001;
2004/12/15 18:00:00;MV2C ;IYK2ZFV1;CEX2 ; 1;50237.83; .5030; .2717;50237.33; .1800; .0001;
2004/12/15 18:00:00;MV2C ;IYK2ZFV1;CSHQ ; 1;50234.95; .3105; .0190;50234.64; .5761; .0001;
2004/12/15 18:00:00;MV2C ;IYK2ZFV1;CSNC ; 1;50393.54; .4259; .0058;50393.12; .0026; .0001;
2004/12/15 18:00:00;MV2C ;IYK2ZFV1;CSNE ; 1;50389.87; .1321; .0177;50389.74; .0074; .0001;
2004/12/15 18:00:00;MV2C ;IYK2ZFV2;CEX2 ; 1;50241.24; .2630; .1828;50240.98; .2255; .0001;
The format of the extract records can be changed by specifying a Report Form. The process for HDB Extract is the same as applying a Report Form to an HDB Report. For more information, see SUMMARY Report Form.
After HDB data has been loaded into an extract data set in CSV format, you can use your favorite PC spreadsheet tool, such as Lotus® Symphony® Spreadsheets or Microsoft Excel, to analyze the data. See Analyzing CSV extract data for examples of how to use such tools to analyze the data.