Question about I/O rate per second for a DB2 package

Nick Nur

Question about I/O rate per second for a DB2 package
Hi colleagues

Our environment is z/OS DB2 v7.1 non-data-sharing. We are in process of migrating to DB2 V8.1. Our monitoring tool is Insight for DB2.

I am having hard time in finding how to compute the I/O rate per second for a DB2 package (Actg classes 7 & 8 are enabled). Can anybody who use Insight help me?

I understand that we have here also MXG database with its DB2 component. Does anybody know if I can get the I/O rate per second for a DB2 package from the MXG database?

Thank you in advance

Nick Nur




__________________________________________________________________
Be smarter than spam. See how smart SpamGuard is at giving junk email the boot with the All-new Yahoo! Mail. Click on Options in Mail and switch to New Mail today or register for free at http://mail.yahoo.ca

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Phil Grainger

Re: Question about I/O rate per second for a DB2 package
(in response to Nick Nur)
The whole point of tuning DB2 apps is to make them do NO I/O AT ALL

Get DB2 doing it all for you (either by prefetch or by reaccessing pages that are already in the bufferpool)

Or are you asking about sync I/O rates?

These ought to be measured at subsystem level and not by application package

Perhaps I have misunderstood what it is you are trying to measure?

Phil Grainger
CA

________________________________

From: DB2 Data Base Discussion List on behalf of Nicola Nur
Sent: Wed 03/12/2008 17:42
To: [login to unmask email]
Subject: [DB2-L] Question about I/O rate per second for a DB2 package



Hi colleagues

Our environment is z/OS DB2 v7.1 non-data-sharing. We are in process of migrating to DB2 V8.1. Our monitoring tool is Insight for DB2.

I am having hard time in finding how to compute the I/O rate per second for a DB2 package (Actg classes 7 & 8 are enabled). Can anybody who use Insight help me?

I understand that we have here also MXG database with its DB2 component. Does anybody know if I can get the I/O rate per second for a DB2 package from the MXG database?

Thank you in advance

Nick Nur




__________________________________________________________________
Be smarter than spam. See how smart SpamGuard is at giving junk email the boot with the All-new Yahoo! Mail. Click on Options in Mail and switch to New Mail today or register for free at http://mail.yahoo.ca < http://mail.yahoo.ca/ >

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms




______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Nick Nur

Re: Question about I/O rate per second for a DB2 package
(in response to Phil Grainger)
Thanks Phil
Few DB2 Packages has been selected to gauge there behaviour before and after migration to v8. One of my metrics (among many) is to see the sync I/O rates per second per package. I differentiate between the amount of synch i/o a package has performed and their rate per second. That is what I am after. Thanks again.
Nick


--- On Wed, 12/3/08, Grainger, Phil <[login to unmask email]> wrote:

> From: Grainger, Phil <[login to unmask email]>
> Subject: Re: [DB2-L] Question about I/O rate per second for a DB2 package
> To: [login to unmask email]
> Received: Wednesday, December 3, 2008, 3:09 PM
> The whole point of tuning DB2 apps is to make them do NO I/O
> AT ALL
>
> Get DB2 doing it all for you (either by prefetch or by
> reaccessing pages that are already in the bufferpool)
>
> Or are you asking about sync I/O rates?
>
> These ought to be measured at subsystem level and not by
> application package
>
> Perhaps I have misunderstood what it is you are trying to
> measure?
>
> Phil Grainger
> CA
>
> ________________________________
>
> From: DB2 Data Base Discussion List on behalf of Nicola Nur
> Sent: Wed 03/12/2008 17:42
> To: [login to unmask email]
> Subject: [DB2-L] Question about I/O rate per second for a
> DB2 package
>
>
>
> Hi colleagues
>
> Our environment is z/OS DB2 v7.1 non-data-sharing. We are
> in process of migrating to DB2 V8.1. Our monitoring tool is
> Insight for DB2.
>
> I am having hard time in finding how to compute the I/O
> rate per second for a DB2 package (Actg classes 7 & 8
> are enabled). Can anybody who use Insight help me?
>
> I understand that we have here also MXG database with its
> DB2 component. Does anybody know if I can get the I/O rate
> per second for a DB2 package from the MXG database?
>
> Thank you in advance
>
> Nick Nur
>
>
>
>
>
> __________________________________________________________________
> Be smarter than spam. See how smart SpamGuard is at giving
> junk email the boot with the All-new Yahoo! Mail. Click on
> Options in Mail and switch to New Mail today or register for
> free at http://mail.yahoo.ca < http://mail.yahoo.ca/ >
>
> ______________________________________________________________________
>
> * IDUG 2009 Denver, CO, USA * May 11-15, 2009 *
> http://IDUG.ORG/lsNA *
> ______________________________________________________________________
>
>
>
> The IDUG DB2-L Listserv is only part of your membership in
> IDUG. The DB2-L list archives, FAQ, and delivery
> preferences are at http://www.idug.org/lsidug under the
> Listserv tab. While at the site, you can also access the
> IDUG Online Learning Center, Tech Library and Code Place,
> see the latest IDUG conference information and much more.
> If you have not yet signed up for Basic Membership in IDUG,
> available at no cost, click on Member Services at
> http://www.idug.org/lsms
>
>
>
>
> ______________________________________________________________________
>
> * IDUG 2009 Denver, CO, USA * May 11-15, 2009 *
> http://IDUG.ORG/lsNA *
> ______________________________________________________________________
>
>
>
> The IDUG DB2-L Listserv is only part of your membership in
> IDUG. The DB2-L list archives, FAQ, and delivery
> preferences are at http://www.idug.org/lsidug under the
> Listserv tab. While at the site, you can also access the
> IDUG Online Learning Center, Tech Library and Code Place,
> see the latest IDUG conference information and much more.
> If you have not yet signed up for Basic Membership in IDUG,
> available at no cost, click on Member Services at
> http://www.idug.org/lsms


__________________________________________________________________
Yahoo! Canada Toolbar: Search from anywhere on the web, and bookmark your favourite sites. Download it now at
http://ca.toolbar.yahoo.com.

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms