How to Create an SMF report using DFSORT ICETOOL

The following JCL is an example on how to use IBM DFSORT ICETOOL utility to produce a report on SMF records (record type 80 in our example):

  
//SMFRPTR  EXEC PGM=ICETOOL                                             
//RAWSMF   DD   DISP=SHR,DSN=SYS2.WEEKLY.SMF(0)                            
//         DD   DISP=SHR,DSN=SYS2.WEEKLY.SMF(-1)                           
//         DD   DISP=SHR,DSN=SYS2.WEEKLY.SMF(-2)                           
//         DD   DISP=SHR,DSN=SYS2.WEEKLY.SMF(-3)                                                     
//TEMPSMF  DD DSN=&&TEMPS,SPACE=(CYL,(15,15)),UNIT=SYSDA                
//REPORT   DD DSN=USER1.SMF.REPORT,DISP=OLD                                                  
//TOOLMSG  DD SYSOUT=*                                                  
//DFSMSG   DD SYSOUT=*                                                  
//TOOLIN   DD *                                                         
   COPY FROM(RAWSMF) TO(TEMPSMF) USING(SMFI)                            
   DISPLAY FROM(TEMPSMF) LIST(REPORT) -                                 
     TITLE('SMF Type-80 Records') DATE TIME PAGE -                   
     HEADER('Time') ON(7,4,TM1,E'99:99:99') - C'hh:mm:ss'               
     HEADER('Date') ON(11,4,DT3,E'9999-999') - C'yyyy-ddd'              
     HEADER('Sys') ON(15,4,CH) -                                        
     HEADER('SMF#') ON(6,1,BI) -                                        
     HEADER('Jobname') ON(55,8,CH) -                                                  
     HEADER('Userid') ON(23,8,CH) -                                               
   BLANK                                                                
/*                                                                      
//SMFICNTL DD *                                                         
  INCLUDE COND=(6,1,BI,EQ,80)                                           
/*                                                                      
//

Explanation:

• DD card SMFRAW points to the SMF dump datasets. In our example, we are using the latest 4 weeks of SMF data.
• DD card TEMPSMF creates a temporary file
• DD card REPORT points to the dataset that will contain the final SMF report produced by the job
• DD card SMFICNTL filters the SMF records by type 80.

The SMF report produced:

SMF Type-80 Records        04/22/15        18:01:27        - 1 -
                                                                
    Time       Date   Sys    SMF#   Jobname    Userid           
--------   --------   ----   ----   --------   --------         
21:29:53   2015-106   DEV1     80              START2           
21:30:00   2015-106   DEV1     80   RMFGAT     START2           
21:30:04   2015-106   DEV1     80   RMFGAT     START2           
21:30:24   2015-106   DEV1     80   SMFCLEAR   START2           
21:31:40   2015-106   DEV1     80   RMFGAT     START2           
21:33:20   2015-106   DEV1     80   RMFGAT     START2           
21:35:00   2015-106   DEV1     80   RMFGAT     START2           
21:36:40   2015-106   DEV1     80   RMFGAT     START2           
21:38:20   2015-106   DEV1     80   RMFGAT     START2           
21:40:00   2015-106   DEV1     80   RMFGAT     START2           
21:41:40   2015-106   DEV1     80   RMFGAT     START2           
21:43:20   2015-106   DEV1     80   RMFGAT     START2           

Notes:

• For more information on the SMF fields, please refer to IBM manual “MVS System Management Facilities (SMF)” – SA22-7630.
• For more information on how to use DFSORT ICETOOL, please refer to IBM manual “DFSORT Application Programming Guide” – SC26-7523.