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.
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.
Joined: 14 Mar 2007 Posts: 8593 Location: Back in jolly old England
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.