Creating a Record Selection extract

The Record Selection extract allows you to create a small extract file containing only the types of SMF records of interest to you. The extract file can then be used as input to CICS PA, allowing for more efficient reporting. The Record Selection extract filters large SMF files, writing only SMF records that match specified criteria.

To request a Record Selection extract:
  1. From the Report Set edit tree, select the Record Selection extract.
      File  Systems  Confirm  Options  Help                                       
    ------------------------------------------------------------------------------
                              Report Set - REPORTS1                    Row 1 of 26
    Command ===> ________________________________________________ Scroll ===> PAGE
                                                                                  
    Description . . . Demonstration Report Set________                            
                                                                                  
    Enter "/" to select action.                                                   
                                                                                  
    ___          ** Reports **                           Active                   
         +  ___  Options                                   Yes                    
         +  ___  Selection Criteria                        No                     
         -  ___  Performance Reports                       Yes                    
                 ___  List                                 No                     
                 ___  List Extended                        No                     
                 ___  Summary                              Yes                    
                 ___  Totals                               No                     
                 ___  Wait Analysis                        No                     
                 ___  Transaction Profiling                No                     
                 ___  Cross-System Work                    No                     
                 ___  Transaction Group                    No                     
                 ___  BTS                                  No                     
                 ___  Workload Activity                    No                     
                 ___  Transaction Tracking List            No
                 ___  Transaction Tracking Summary         No
         +  ___  Exception Reports                         No                     
         +  ___  Transaction Resource Usage Reports        No                     
         +  ___  Statistics Reports                        No                     
         +  ___  Subsystem Reports                         No                     
         +  ___  System Reports                            No                     
         +  ___  Performance Graphs                        No                     
         -  ___  Extracts                                  Yes                    
                 ___  Cross-System Work                    No                     
                 ___  Performance                          No                     
                 S__  Record Selection                     Yes                    
                 ___  HDB Load                             No                     
                 ___  System Logger                        No                     
                 ___  Statistics                           No                     
                 ** End of Reports **                                             
  2. Specify record selection options. Select all record types and specify the name of the output data set.
      File  Systems  Options  Help                                                
    ------------------------------------------------------------------------------
                          REPORTS1 - Record Selection Extract                      
    Command ===> _________________________________________________________________
                                                                                  
    System Selection:                                                             
     CICS APPLID . . ________  +  Image . . ________  +  Group . . ________  +    
     DB2 SSID  . . . ____  +      Image . . ________  +  Group . . ________  +    
     MQ SSID . . . . ____  +      Image . . ________  +  Group . . ________  +    
     Logger  . . . . ________  +  Image . . ________  +  Group . . ________  +    
                                                                                  
    Required Record Types:                       Extract Recap:                   
     /  Performance       /  Exception            DDname  . . . RSEL0001          
     /  Resource          /  Statistics                                           
     /  OMEGAMON          /  DB2                                                  
     /  WebSphere MQ      /  System Logger                                        
     /  Identity                                                                  
                                                                                  
    Output Data Set:                                                              
     Data Set Name  . . 'GSG.RECSEL.EXTRACT'__________________________            
     Disposition  . . . 1  1. OLD       Record Compression  . . 1  1. No          
                           2. MOD                                  2. Yes         
                                                                                  
    Selection Criteria:                                                           
     _  Performance                                                               
     _  Exception                                                                 
                                                                                  
    Logger Selection Criteria:                                                    
     _  Logger                                                                    
        Logstream Name . . . __________________________                           
        Structure Name . . . ________________                                     
                                                                                  
    Note:
    • In this example, we selected all record types to allow you to use the extract file for all CICS PA functions that you may want to try. However, you may choose not to include certain record types to reduce the file size and improve performance.

      As a minimum, select Performance and Statistics record types if you intend to use the Record Selection extract file instead of the original SMF file to complete the reporting exercises in this tutorial.

    • CICS PA will generate JCL to allocate the extract data set if it is not already defined. If the data set is already defined, it will be processed according to the Disposition option selected.
  3. Exit to save the extract options. Exit again to return to the Report Set edit panel.
  4. Enter RUN on the command line of the Report Set panel.
  5. On the run-time prompt panel, specify appropriate options, select to edit JCL before submit, then press Enter.
  6. CICS PA generates the JCL and displays it in an ISPF edit session.
     . . .
     ===> SUB_____________________________________________ Scroll ===> CSR_
     . . .
     //* Command Input
     //SYSIN DD *
     * Report Set =REPORTS1
              CICSPA IN(SMFIN001),
                     APPLID(*),
                 SUMMARY(OUTPUT(SUMM0001),       
                     EXTERNAL(CPAXW001),         
                     TOTALS(8),                  
                     INTERVAL(01:00:00),         
                     FIELDS(START(TIMES,ASCEND), 
                            TRAN(ASCEND),        
                            TASKCNT,             
                            RESPONSE(AVE),       
                            RESPONSE(MAX),       
                            DISPATCH(TIME(AVE)), 
                            CPU(TIME(AVE)),      
                            SUSPEND(TIME(AVE)),  
                            SUSPEND(TIME(MAX)),  
                            DISPWAIT(TIME(AVE)), 
                            FCWAIT(TIME(AVE)),   
                            FCAMCT(AVE),         
                            IRWAIT(TIME(AVE)),   
                            SC24UHWM(AVE),       
                            SC31UHWM(AVE))),     
                 RECSEL(OUTPUT(RSEL0001),        
                        DDNAME(CPAORS01),        
                     PERFORMANCE,                
                     EXCEPTION,                  
                     RESOURCE,                   
                     STATISTICS,                 
                     OMEGAMON,                   
                     LOGGER,                     
                     DB2,                        
                     MQ,                         
                     IDENTITY,                   
                     NOCOMPRESS)                 
     /*
  7. Make any necessary changes, then enter the SUBmit command to submit the job.

When the job completes, review the report output and the extract data set.


Information Information

Feedback


Timestamp icon Last updated: Friday, 8 February 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//cpags490.htm