[DB2 for z/OS] Benchmarks and CPU

Mark Vickers

[DB2 for z/OS] Benchmarks and CPU
I am trying to benchmark some DB2 tools.
When I look at the JOB stats, the CPU time is < 4% of elapsed time.
All things aside, I know there was a lot more work done than that.
Does DB2 cpu time get registered somewhere else ?
thanks,
Mark.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Phil Grainger

Re: [DB2 for z/OS] Benchmarks and CPU
(in response to Mark Vickers)
Hi Mark

"It depends" on which tools you mean

For example, IBM utilities can do most of their work "inside" DB2 so the
cpu time may not show up where you expect it to, whilst third parties
utilities behave more like you would expect

More details might help

Phil Grainger
CA
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125752
[login to unmask email]


________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Mark E Vickers
Sent: 06 December 2006 17:07
To: [login to unmask email]
Subject: [DB2-L] [DB2 for z/OS] Benchmarks and CPU



I am trying to benchmark some DB2 tools.
When I look at the JOB stats, the CPU time is < 4% of elapsed time.
All things aside, I know there was a lot more work done than that.
Does DB2 cpu time get registered somewhere else ?
thanks,
Mark.


------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm