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 above, 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 V3R2 HDB EXTRACT 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//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 bottom 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. V3R2M0 CICS Performance Analyzer
Historical Database Summary
HXTS0001 Printed at 12:03:45 3/15/2011 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;