MVSFORUMS.com

rsk123in · Beginner Joined: 03 Mar 2003 Posts: 8 Topics: 6

what dfsorting method have i to implement to get the smf record 88 in a required format.

pls help

rsk

Frank Yaeger · Posted: Thu Mar 27, 2003 11:24 am Post subject:

Please clarify what you want, e.g, what "required format"?
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

Bill Dennis · Posted: Thu Mar 27, 2003 3:13 pm Post subject:

Is your format "problem" related to the spanned format of the raw SMF data (a logical record may be part of more then one physical record)?

Bill

rsk123in · Beginner Joined: 03 Mar 2003 Posts: 8 Topics: 6

dear frank,

I want to sort the smf record type 35 subtype 23 in the order of group id,user id, time logged off, time logged on etc., which i have dumped for sys1.man1 in a ps organization and the record format is vbs. how can i sort this file,

pls help

rsk

Frank Yaeger · Posted: Mon Mar 31, 2003 11:34 am Post subject:

rsk,

DFSORT can sort a VBS input file just like a VB file. Just remember that the first 4 bytes of a VBS or VB file is the RDW, so the data starts at position 5. Use the INCLUDE statement to select the record type 35, subtype 23 records, and use the SORT statement to sort by the group id, user id, time logged off, time logged on, etc.
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort