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.

In this example, we have selected our statistics HDB for extracting to CSV.
Figure 1. HDB Extract
  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 ********************************
The list of statistics reports is displayed. Select the reports that you want to extract to CSV.
Figure 2. Select Statistics reports for CSV extract
  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 **                                             
We have selected the DSAs report.

The run extract panel is displayed.

Figure 3. Run Statistics HDB Extract
                     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.

If you selected Edit JCL before submit then the extract JCL is generated and displayed in an edit session for review and submission.
Figure 4. Edit JCL for Statistics HDB Extract
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".


Information Information

Feedback


Timestamp icon Last updated: Thursday, 7 November 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//guided-tours/cpaug295.htm