IBM Mainframe Forum

Hello,

I would like to find programs of an application that impact performance and that should be improved.Is there some tool that allow to know how many times a program has been executed on the zOS and what is its average execution time?

My goal is to send this information onto Windows in order to process it. So the tool must provide to export information in a Windows readable text format.

Hello,

All of the information about jobs that have executed is in the SMF records.

There are probably already jobs run daily, weekly, or monthly that organize this info by job and by program (most organizations have such processes running).

Suggest you talk with your system support people and find out what is available before you waste a lot of time and system resources re-creating something that already exists.

If you parse an existing report or write something more custom, it is a trivial matter to write the file as a delimited text file (the tab character x'05' works well) and ftp this file to some Windows server for local use.

Hi Dick,

Thanks for your answer. I agree with you to avoid wasting time to recreate existing infos. Are SMF infos always available or people can deactivate their production?

Regards

Hello,

Are SMF infos always available or people can deactivate their production?

Some amount of SMF data is always available. I've not seen anywhere that people could selectively deactivate "their" information. Not all systems capture all of the same information. Suggest you speak with the people who use the current SMF data and see what is available.

Ok. So it is possible to have CPU time for online and batch programs. I am going to speak about his with system people.

Do you know other similar tools?

Regards

Hello,

So it is possible to have CPU time for online and batch programs.

Yes.

Do you know other similar tools?

SMF captures data. . . It is common across all mvs-style installations. It is not a "tool" - things that report against the smf data are tools - and there are very many.

I am going to speak about his with system people

They can tell you what is already available on your system.

dick scherrer wrote:I've not seen anywhere that people could selectively deactivate "their" information.

In PARMLIB member SMFPRMxx you can select the SMF record types to be written or not written.

Hi Bill,

Yup, but by record type.

User ax713r cannot do anything that would prevent smf records for userid=ax713r from being written can they?

Hi both,

I am going to investigate on how to have SMF infos. It is interesting to know if some programs are time consuming. This may mean that there is probably something to do to improve their performance.
Potential causes could be in loops or in database accesses (bad WHERE clauses or missing indexes). What do think about that?

Hello,

The amount of time taken is not necessarily an indicator of poor performance. . .

Some tasks are simply big tasks. Some tasks become big due to very poor design - like passing a 300 million record file 5 times in utility steps rather than writing one programs that could accomplish the same real work.

Loops tend to identify themselves by having a time-out abend.

Poor database design and/or "bad" WHEREs often cause major performance problems. Especially when all of the pre-Production testing was done with insufficient data. Something that runs sub-second for 100 rows may grind completely to a halt with several million. . .