INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

CPU Time Batch Job accessing DB2 - Z/OS

CPU Time Batch Job accessing DB2 - Z/OS

(OP)
I am tuning a DB2 batch program.  I dont have access to a good monitor.  So I will compare CPU times.  My question is:

When a batch job finishes, it shows excp, cpu time, etc.

What does the CPU time represent?  Does it represnet the time only for the app's TCB or does it include the time spent in the DB2 subsystem's TCB also?

RE: CPU Time Batch Job accessing DB2 - Z/OS

Mike,
I believe that the CPU time shown for the step/job is the total CPU for that step/job. If CPU is used outside of DB2, then this is included in that total.

One thought which occured to me which was whether you are able to add EXPLAIN to the bind statements. This will not only give you a PLAN_TABLE to look at, but if you have a DSN_STATEMNT_TABLE also allocated, you can look at the estmiated costs of each specific SQL statement within the program.

Hope this helps,

Marc   

RE: CPU Time Batch Job accessing DB2 - Z/OS

(OP)
Thanks,

Fred, my thoughts were that it does include both/all.  I have a call into the db2 sysprog as to the monitors that are available.

Marc,
I have run explain extensively and created an index to help with access paths.  This does the trick.  Now I am trying to put together objective run time stats to back up my recomendations.  Hence, the cpu time query.

BTW,
The EXCP count must be channel io for the app only - not all the io for the DB2 subsystem.  Agreed?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close