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
 

 

SMF Type 5

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IBM Tools
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    Post subject: SMF Type 5
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    Post subject:
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: 8124
Location: East Dubuque, Illinois, USA

PostPosted: Fri Apr 16, 2010 3:22 am    Post subject:
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    Post subject:
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

Site Director


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

PostPosted: Fri Apr 16, 2010 5:23 am    Post subject:
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: 2150
Location: At my coffee table

PostPosted: Fri Apr 16, 2010 5:24 am    Post subject:
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    Post subject:
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

Site Director


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

PostPosted: Tue Apr 20, 2010 3:07 am    Post subject: Reply to: SMF Type 5
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: 2435
Location: Netherlands, Amstelveen

PostPosted: Tue Apr 20, 2010 2:22 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> IBM Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm
No new posts SORT JSON type of data maxsubrat DFSORT/ICETOOL 8 Wed Apr 19, 2017 6:01 pm
No new posts Ccompar BLOB (images of type jpg) on ... nihad DB2 0 Sun Feb 05, 2017 3:13 pm
No new posts Query using SUBSTRING on a column of ... sasanka DB2 5 Mon Jul 04, 2016 1:01 pm
No new posts Invalid frequency code, dataset descr... Bhanu Praveen JCL & VSAM 4 Fri Feb 05, 2016 10:43 am


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