Reading SMF 100-102 records

avik1983 · New User Joined: 11 Mar 2010 Posts: 5 Location: Chennai

I Have extracted SMF 100-102 records using JCL.
SMF record description -
100 - (DB2) Statistics
101 - (DB2) Accounting
102 - (DB2) Performance Trace

Now I want to read the SMF dataset to create the DB2 accounting Report as by using JCL we can do directly.I want to do the same by a program(If possible, Cobol). If someone can help by provoding any program to read SMF & to prepare accounting statistics report, It will be helpful.

Thanks in Advance

expat · Posted: Fri Dec 10, 2010 2:40 pm

Please oh please, do NOT say that you do things using only JCL, because you do not,
you use the JCL to invoke a program which actually does the processing

I would have a chat with your performance and capacity people who probably already have the reports at hand using something like SAS with MXG or MICS.

Why reinvent the wheel when the latest model works just fine

avik1983 · New User Joined: 11 Mar 2010 Posts: 5 Location: Chennai

You are right!! But we don't have MXG or MICA in shop.
We generally prepare report invoking program through JCL. Some time DBA doesn't allow to run the same. In that case having a program which can process SMF data will do good.
If you can help providing any guidance, it will be helpful.

expat · Posted: Fri Dec 10, 2010 3:15 pm

You need to speak to the people responsible for your capacity and performance monitoring, or maybe even the sysprogs, depending on how your site is set up.

These people will almost certainly have the kind of report that you want already available, or easily creatable. I can not think of a single site that I have worked at since about 1980 that has not had this in place.