Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Format SMF 64 record type

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Ajay Baghel

Active User


Joined: 25 Apr 2007
Posts: 205
Location: Bangalore

PostPosted: Mon Aug 10, 2009 12:58 pm    Post subject: Format SMF 64 record type
Reply with quote

Hi Friends,

I want to format the information into an understandable format from the record type SMF 64 . I have done the extract from SYS1.MAN dump dataset 's backup file to a my VBS dataset.

I want to format the information about the VSAM activity for a given VSAM dataset which is used in a particular jobname.

I do not know assembler but i am ready to learn SAS if required. Also if we know the format, will it be possible to infer the information using SORT tool (syncsort) ?

Please throw some light in the direction in which i need to proceed (like manuals i need to go thru or skills i need to acquire for learning this)?

Thanks,
Ajay
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Mon Aug 10, 2009 1:27 pm    Post subject:
Reply with quote

To read about SMF records click HERE
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7931
Location: Bellevue, IA

PostPosted: Mon Aug 10, 2009 5:02 pm    Post subject:
Reply with quote

Contact your site support group and find out if they use MXG, MICS, or any other SMF analysis tool. Running through the output of one of these tools is much simpler than handling the raw data yourself.

The code, in SAS or assembler or whatever, is not easy since you must do bit-level manipulations and work with variable numbers of variable length groups. I certainly would not recommend a newcomer to SAS start by attempting to process SMF data -- that would be like telling an architecture student her first assignment is to design a 90-story skyscraper!
Back to top
View user's profile Send private message
Ajay Baghel

Active User


Joined: 25 Apr 2007
Posts: 205
Location: Bangalore

PostPosted: Sun Aug 16, 2009 9:34 pm    Post subject:
Reply with quote

Robert,

Our support people are using MXG. I do not now the full process yet how they are processing the SMF data.

But i see that SMF data can be interpreted in REXX for which i got some examples on CBTTAPE .

I will try it thru REXX.

Thanks
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7931
Location: Bellevue, IA

PostPosted: Sun Aug 16, 2009 9:51 pm    Post subject:
Reply with quote

MXG converts the SMF data into a set of SAS data sets that can be analyzed with much, much less trouble than attempting to process the raw SMF data. The MXG TYPE64 and TYPE64X records are what you need to use in SAS. Use them instead of redoing the work already completed by MXG to determine what the data is. I strongly recommend using the MXG data even if you have to learn some SAS to use them -- it will take no longer to learn the SAS code you need than it would take to figure out the details of the SMF records.

SMF processing usually is done after midnight each night for the accumulated data for the day. MXG usually has a weekly or monthly accumulation of the daily records.
Back to top
View user's profile Send private message
Ajay Baghel

Active User


Joined: 25 Apr 2007
Posts: 205
Location: Bangalore

PostPosted: Tue Aug 18, 2009 8:35 pm    Post subject:
Reply with quote

Thanks a lot Robert!!
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to update a portion of text in a ... Bill Woodger DFSORT/ICETOOL 25 Wed Nov 09, 2016 9:41 pm
No new posts Match or compare two files in VB Format anatol DFSORT/ICETOOL 14 Thu Nov 03, 2016 7:41 pm
No new posts Low values Results from VARCHAR FORMAT balaji81_k DB2 10 Thu Oct 20, 2016 1:18 am
No new posts output data in CSV Format janmejay COBOL Programming 8 Sat Oct 15, 2016 2:20 pm
This topic is locked: you cannot edit posts or make replies. output data in CSV Format janmejay DFSORT/ICETOOL 3 Sat Oct 15, 2016 2:16 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us