Extracting Statistics HDB data to CSV
Select option 6 Extract from the HDB menu to request an HDB extract.
The HDB Extract facility allows you to export data from your HDB data sets to an Extract data set in CSV format, suitable as input into PC-based spreadsheet applications.
File Options Help
------------------------------------------------------------------------------
Extract HDBs Row 1 to 1 of 1
Command ===> ________________________________________________ Scroll ===> CSR_
Select to extract HDB.
Name Type Description Changed ID
S CICSP1S STATS Statistics HDB for CICSP1 2005/03/16 12:23 JCH
****************************** Bottom of data ********************************
File Edit Options View Help
------------------------------------------------------------------------------
Statistics Reports Line 1 of 26
Command ===> ________________________________________________ Scroll ===> CSR_
Select reports to extract.
DB2
___ ** Reports ** Collect Load
- ___ Regions Yes No
___ Transaction Manager Yes No
___ Monitoring No No
- ___ CICS Dispatcher Yes No
___ Dispatcher Overview Yes No
___ Dispatcher TCB Modes Yes No
___ Dispatcher TCB Pools Yes No
___ MVS TCB Overview Yes No
___ MVS TCBs Yes No
- ___ CICS Storage Yes No
___ Storage Overview Yes No
S__ DSAs Yes No
___ Domain Subpools Yes No
___ Task Subpools Yes No
+ ___ CICS Dumps Yes No
___ Enqueue Pools Yes No
+ ___ Connectivity No No
+ ___ Files and Databases No No
+ ___ Logging No No
+ ___ Queues No No
⋮
The run extract panel is displayed.
Run STATS HDB Extract – CICSP1
Command ===> ______________________________________________________________
Specify run options then press Enter to continue submit.
----- Report Interval ------ HDB contains data
YYYY/MM/DD HH:MM:SS.TH in the range:
From 2005/03/16 08:00:00.00 2005/03/15 07:00 Extract Recap:
To 2005/03/16 09:00:00.00 2005/03/16 11:00 DDname . . . HXTS0001
Output Data Set:
Data Set Name Prefix . . 'JCH.CICSPA.EXTRACT'__________________
Disposition . . . . . . 1 1. OLD 2. MOD (If cataloged)
Extract Format: Enter "/" to select option
Delimiter . . . . . . . ; / Include Field Labels
Enter "/" to select option
/ Edit JCL before submit
Specify the required reporting interval, data set name and other formatting options, then press Enter to proceed.
EDIT JCH.SPFTEMP3.CNTL Columns 00001 00072
Command ===> ________________________________________________ Scroll ===> PAGE
****** ***************************** Top of Data ******************************
000001 //JCH#CPA JOB ,NNOTIFY=&SYSUID
000002 //* CICSPA V5R1 HDB Extract JCL
000003 //CICSPA EXEC PGM=CPAMAIN
000004 //STEPLIB DD DSN=CPA.SCPALINK,
000005 // DISP=SHR
000006 //CPAHDBRG DD DSN=CPA.HDB.REPOSTRY,
000007 // DISP=SHR
000008 //SYSPRINT DD SYSOUT=*
000009 //* DSAs
000010 //STAT014B DD DSN=JCH.SDS.STAT014B,
000011 // DISP=(NEW,CATLG),
000012 // UNIT=SYSDA,SPACE=(CYL,(10,10))
000013 //SYSIN DD *
000014 * STATS HDB=CICSP1
000015 CICSPA SMFSTART(2005/03/16,08:00:00.00),
000016 SMFSTOP(2005/03/16,09:00:00.00)
000017 CICSPA LINECNT(60),
000018 FORMAT(':','/'),
000019 HDB(EXTRACT(CICSP1),OUTPUT(HXTS0001),
000020 LABELS,DELIMIT(';'),
000021 STAT014B(STAT014B)) DSAs
000022 /*
000023 //* HDB Container Data Sets. HDB Extract 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=CICSPA.CICSP1.D05074.T102306.HDB
000030 //HDB00002 DD DISP=SHR,DSN=CICSPA.CICSP1.D05074.T152311.HDB
000031 //HDB00003 DD DISP=SHR,DSN= CICSPA.CICSP1.D05075.T042316.HDB
****** **************************** Bottom of Data ****************************
Multiple statistics reports can be extracted in a single request.
Note that, like DB2® tables, CICS® PA appends the statistics ID suffix to the extract data set name. Data set JCH.SDS.STAT014B can now be file transferred to your workstation for importing into a spreadsheet application.
CICS PA extracts CICS TG statistics to data set names with the low-level qualifier "HSTGnnnn". This distinguishes them from CICS TS statistics, which CICS PA extracts to data set names with the low-level qualifier "STATnnnn".