Hillario Garcia, Eladarus has shown you an example job of how you can generate counts using OCCUR. you can modify that to suit your needs. If you still need help, please answer the following questions as I am not that familiar with SMF30 records
1. How are you extracting the values Userid, Jobname from SMF? 2. Which subtype records are you interested in? 3. If you want DFSORT to extract the values from Raw SMF data then what fields correspond to Userid, Jobname(SMF30JBN ??) and Date from the SMF-30 Record mapping? Remember the raw smf have variable length segments where the offset and the length are stored in the record and you need dynamically access the information which would require an addition pass of data. 4.If you have the data extracted then it is simple to generate the weekly/monthly/yearly report. Thanks, Kolusu IBM Mainframe Discussion List <[email protected]> wrote on 02/04/2016 05:47:44 AM: > From: Hilario Garcia <[email protected]> > To: [email protected] > Date: 02/04/2016 05:58 AM > Subject: Count smf type 30-5 records > Sent by: IBM Mainframe Discussion List <[email protected]> > > Hello folks, > > I need to extract some data from SMF type 30. The info are: > > Userid > Jobname > Count (by Jobname on an expecific month) > > I had tried using IBM Dfsort, but I can't get the number of a > specific jobname on a user and on one month. I need this information: > > USERID JOBNAME COUNT > user1 joba 2 > jobb 18 > jobc 1 > > user2 jobx 3 > > user3 joby 2 > jobz 3 > > I had tried several Dfsort jobs but didn't work or the results are > different to the correct. > > I haven't any additional software like SAS, MXG, ... > > Any suggestion on how to code a valid Dfsort for that ? Any example ? > > Thanks in advance. > > Kind Regards. > > Hilario > > > > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
