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 - ___ 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 + ___ Transactions No No + ___ Programs No No + ___ CICS Web Support No No + ___ Enterprise Java No No + ___ Miscellaneous No No + ___ CICS Server No No + ___ CICS Transaction Gateway No No ** End of Reports **
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".