IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SMF Type 5


IBM Mainframe Forums -> IBM Tools
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
MFSubbu

New User


Joined: 16 Feb 2008
Posts: 19
Location: Bangalore

PostPosted: Fri Apr 16, 2010 2:31 am
Reply with quote

Hi,

My Requirement is to get the job name, job start time, job end time, job run time(duration it takes for the job to complete).

I tried using SMF type 5. There were aroung 50K records. I splitted them into 10K each and then using REXX i filtered the required information. The start time (SMF5RST) and the end time(SMF5RSTT) remains the same for all job, I am not sure why it is so. I also thought of achieving this through SMF type 30. but in this i have 500,000 records. Below are my questions

1) Rexx is not capable of reading large file and it is not efficient as well.. is there any other way to achieve the output other than using REXX

2) Why the start time and end time of the output remains the same. Manually i checked few jobs which run for longer time, even for those both the time remains the same.

3) I parsed SMF5TRAN and SMF5TTAT to findout which gives the job run time information, but both didnt give me the run time.
Back to top
View user's profile Send private message
Bill Dennis

Active Member


Joined: 17 Aug 2007
Posts: 562
Location: Iowa, USA

PostPosted: Fri Apr 16, 2010 2:58 am
Reply with quote

Those fields are the time spent getting the job through the INTRDR. That is very quick.

The field you want to use are
SMF5JIT - job initiation time
SMF5TME - job end time

The difference between them is runtime. Don't forget the job many end on the next day or several days later. Check those fields, too.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Fri Apr 16, 2010 3:22 am
Reply with quote

Also note that when IBM recommends something, wise programmers pay heed. From the SMF manual:
Quote:
Note: IBM recommends that you use record type 30 rather than record types 4, 5, 20, 34, 35, and 40. Use of record type 5 may cause you to miss key workload indicators.


Have you checked with your site support group to see if they are using MICS or MXG or another package that processes SMF data into easily usable SAS data bases or flat files?
Back to top
View user's profile Send private message
MFSubbu

New User


Joined: 16 Feb 2008
Posts: 19
Location: Bangalore

PostPosted: Fri Apr 16, 2010 4:51 am
Reply with quote

Bill,

Now it is working fine..

Robert,

We donot have any package to convert SMF data.

After fetching the result only I noticed the output includes all the jobs submitted by the scheduler and also by the users.. Is there any way i can filter the jobs submitted by the scheduler alone. I mean to get the OWNER of the job from SMF data. I could see SMF30JNM will fetch that info... but as i said SMF typer 30 fetching 5 lakh records and REXX will not be able to read the file. Is there any way to filter only the jobs submitted by the scheduler.

Thanks in advance...
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Fri Apr 16, 2010 5:23 am
Reply with quote

Hello,

Why do you believe this all must be done with rexx?
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table

PostPosted: Fri Apr 16, 2010 5:24 am
Reply with quote

Doesn't DFsort have some good facilities to read and prune some of those SMF type 30 records prior to feeding them to REXX?
Back to top
View user's profile Send private message
MFSubbu

New User


Joined: 16 Feb 2008
Posts: 19
Location: Bangalore

PostPosted: Tue Apr 20, 2010 2:36 am
Reply with quote

Thanks everyone...

I used Syncsort to filter the records and then used REXX to generate the report and it worked....
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Apr 20, 2010 3:07 am
Reply with quote

Good to hear you have a solution - thank you for letting us know icon_smile.gif

d
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen

PostPosted: Tue Apr 20, 2010 2:22 pm
Reply with quote

SMF5Rxxx is the reader start/stop time. And that will be almost always
be the same.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IBM Tools

 


Similar Topics
Topic Forum Replies
No new posts SMF record type 30 JCL & VSAM 8
No new posts Selective extract of multi-record-typ... SYNCSORT 4
No new posts Changing Data Type SYNCSORT 4
No new posts REXX for Reading SMF type 70-1 Testing & Performance 6
No new posts Migrating AS400 to HIVE; Data type ma... All Other Mainframe Topics 1
Search our Forums:

Back to Top