Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Performance Measure of IMS/DB2 Batch jobs

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
Nagendran

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Wed May 27, 2009 4:14 am    Post subject: Performance Measure of IMS/DB2 Batch jobs
Reply with quote

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.....
Back to top
View user's profile Send private message

aknatva

New User


Joined: 21 May 2009
Posts: 6
Location: hyderabad

PostPosted: Wed May 27, 2009 9:27 am    Post subject:
Reply with quote

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.,
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: Wed May 27, 2009 9:52 am    Post subject:
Reply with quote

Hello,

Quote:

CPU time is the correct measure of performance of a job/process
CPU time is one measure of performance - it is not the only one and often not the most important.

For your particular situation, i believe the performance of IMS and DB2 are quite important also.

Suggest you talk with your dba(s) and ask what they use to measure database processes.

As mentioned, STROBE is very useful.
Back to top
View user's profile Send private message
Nagendran

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Wed May 27, 2009 10:31 am    Post subject: Reply to: Performance Measure of IMS/DB2 Batch jobs
Reply with quote

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
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed May 27, 2009 4:01 pm    Post subject:
Reply with quote

As suggested earlier, did you talk with your dba(s) and ask what they use to measure database processes?
Back to top
View user's profile Send private message
Nagendran

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Wed May 27, 2009 7:20 pm    Post subject: Reply to: Performance Measure of IMS/DB2 Batch jobs
Reply with quote

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
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 -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Accessing CICS tran with map from JCL... navdeepaggarwal CICS 5 Tue Oct 03, 2017 6:15 pm
No new posts ejck thru rexx to multiple jobs insid... Susanta All Other Mainframe Topics 5 Tue Sep 19, 2017 1:39 pm
No new posts Generate public-private key in batch ... vasanthz All Other Mainframe Topics 3 Fri Sep 15, 2017 9:20 am
No new posts Working with hex values in Filemanage... Emile Straker IBM Tools 0 Tue Sep 12, 2017 1:42 am
No new posts self-restarting jobs in OPC jzhardy IBM Tools 1 Mon Aug 21, 2017 10:15 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us