Performance Measure of IMS/DB2 Batch jobs

Nagendran · New User Joined: 24 Jan 2007 Posts: 89 Location: USA

Hi,

I have a Job which updates around 10,000 records to IMS/DB2 database.

I need to come up with certain parameters to measure performance between Production run(Existing code) and Test Run(Modified code). At present i am using CPU time to compare the performance of test Job and Production Jobs runs.

Do any body know any other parameters that can be used to calculate the performance?

I have One more job which simply validates the records in the input file by accessing lots of IMS/DB2 database(more than 30).. I need to come up with parameters for performance measure of same.

Could any body help me with this?

Thanks,
Nagu.....

aknatva · New User Joined: 21 May 2009 Posts: 6 Location: hyderabad

Hi Nagendran,

CPU time is the correct measure of performance of a job/process, but you can also check for elapsed time on few situations ( some times, we want to improve SLAs).

If you have STROBE tool available on your shop, you can try running the jobs with STROBE and that can give you a very detail level information on which module is consuming how much CPU etc.,

dick scherrer · Posted: Wed May 27, 2009 9:52 am

Hello,

Nagendran · New User Joined: 24 Jan 2007 Posts: 89 Location: USA

Hi All,

Thanks for your responses.

My requirement is to come up with a benchmark for each Job.
For eg: Consider if a job takes 300MS to complete the execution in production. We will be running the same Input file with New changes and will be comparing the CPU time of test run(new changes) with Production run.

Our main intention is to identify whether we have performance issues or not. We are not worried about the modules and databases which creates the issues.

We dont have strobe tool in our system. Is there any other tool or Utilities available to identify the performance tuning of Jobs. And also is there any utilities available to calculate the performance of each modules.

Is CPU time is the Best parameters ??? Do you have any other suggestions???

Thanks,
Nagendran.R

Anuj Dhawan · Posted: Wed May 27, 2009 4:01 pm

As suggested earlier, did you talk with your dba(s) and ask what they use to measure database processes?

Nagendran · New User Joined: 24 Jan 2007 Posts: 89 Location: USA

Hi,

Thanks.. let me check with my DBA..

One more question....

I am running Job with same Load Modules pointing to Production region ana test region. But there is a strong deviation of CPU time utilization between Production and Test region. Is there any system resources othere than load modules is deciding the CPU time?

Thanks,
Nagendran.R