On Feb 4, 2016, at 3:52 PM, Robert A. Rosenberg wrote:

At 13:16 -0700 on 02/04/2016, Sri h Kolusu wrote about Re: Count smf type 30-5 records:

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.

Due to the variable length segment issue, just using Sort Cards to map the file is not going to fly well. IMO, the simplest way of extracting the needed fields is to just have someone who is capable of writing simple Assembler code to just write a program to extract the fields and output a simple file with them. This file can then be sent through the sort which consolidates and counts them to output a report whenever a field changes.

I know that you are looking for a way to have sort handle all the work, but doing the record selection/parsing is better delegated to something that can locate the data. Back in the when I was still coding, this type of task was one that I would toss off as a Quick&Dirty project in an hour or two.

I don't know off the top of my head but EASYTRIEVE ($) can do it without even breaking a sweat in probably 6 or 7 lines of code (or less).
SAS should be able to do it as well ($$$$$$).

Ed

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Reply via email to