Sri h Kolusu wrote :

>>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 ...

In 'Identification Section' :

Userid = SMF30RUD 
Group = SMF30GRP 
Jobname = SMF30JBN

>and you need dynamically access the information which would require an 
>addition pass of data.

And taking in account that some segments are NOT there. (Offset = 0, Length = 0 
and Quantity = 0 for that segment)


and Robert A. Rosenberg wrote:

>Due to the variable length segment issue, just using Sort Cards to map the 
>file is not going to fly well. 

Both of you are right. My ICETOOL example a$$umed the records were written 
correctly and I have dumped those records to verify that the DFSORT jobs can 
handle them. Any part of the record next to the standard header is just random 
in terms of quantity, length and contents. You have to scan from left to right, 
checking your Type and SubType and then work out those subtypes with their 
offsets, lengths and quantities.


>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. 

Agreed. I have some Assembler programs handling those segments. You quickly 
re-learn how to count. ;-)


>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. 

Agreed. DFSORT is a general purpose tool. For more specific handling or further 
subsetting of records, you need to use something else or invent a new wheel.

Groete / Greetings
Elardus Engelbrecht

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN

Reply via email to