[z/OS v7] Baseline CPU and Storage usage

Mark Vickers

[z/OS v7] Baseline CPU and Storage usage
If anyone was able to create a baseline of CPU usage and Storage usage for
DB2 v7 and IRLM,
could you share some details about your capture methods please.

I can get all sorts off stats about what happened within DB2 and as a % of
what DB2 used, but I want
to measure what % of the whole machine the started tasks are using ?

So far we are not coming up with a satisfactory solution, with any of our
monitoring software products,
and I want a baseline to compare to v8 (unless there is another way to do
this ?)

We have BMC Mainview for z/OS,CICS,DB2, BMC Visualizer, BMC Apptune for
DB2 and of course a
few billion SMF records (still looking at those).

Thanks,
Mark Vickers.



Jorg Lueke <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
01/21/2008 10:10 AM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
SMF Accounting Question






Why does Class2 and Class3 Parallel CPU usage gt reported in SMF but not
back to the job that is executing. If I look in the SDSF output I only
see the
Class1 CPU time accounted.

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the 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





This e-mail (and any attachments) may contain information that is
confidential and/or protected by law. Any review, use, distribution or
disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the intended
recipient, please contact the sender by reply email and delete all copies
of this message.



The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the 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

Brian Bear

Re: [z/OS v7] Baseline CPU and Storage usage
(in response to Mark Vickers)
I capture package level, plan level, user level stats using BMC's Performance Reporter. I capture weekly averages and download/import into an excel spreadsheet.

I do not have anything at the started task level though. I have looked into it but never figured out how I could do it.

I'd be very interested in a solution as well.



Brian.


________________________________________
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of [login to unmask email]
Sent: Monday, January 21, 2008 11:36 AM
To: [login to unmask email]
Subject: [DB2-L] [z/OS v7] Baseline CPU and Storage usage


If anyone was able to create a baseline of CPU usage and Storage usage for DB2 v7 and IRLM,
could you share some details about your capture methods please.

I can get all sorts off stats about what happened within DB2 and as a % of what DB2 used, but I want
to measure what % of the whole machine the started tasks are using ?

So far we are not coming up with a satisfactory solution, with any of our monitoring software products,
and I want a baseline to compare to v8 (unless there is another way to do this ?)

We have BMC Mainview for z/OS,CICS,DB2, BMC Visualizer, BMC Apptune for DB2 and of course a
few billion SMF records (still looking at those).

Thanks,
Mark Vickers.

Jorg Lueke <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
01/21/2008 10:10 AM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>

To
[login to unmask email]
cc

Subject
SMF Accounting Question







Why does Class2 and Class3 Parallel CPU usage gt reported in SMF but not
back to the job that is executing.  If I look in the SDSF output I only see the
Class1 CPU time accounted.

The IDUG DB2-L Listserv is only part of your membership in IDUG.  DB2-L list archives, the 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



This e-mail (and any attachments) may contain information that is confidential and/or protected by law. Any review, use, distribution or disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and delete all copies of this message.


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at www.idug.org 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

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the 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

Mark Vickers

Re: [z/OS v7] Baseline CPU and Storage usage
(in response to Brian Bear)
Seems strange, answering my own email...

I hope someone will give me more, but at this point the best I can come up
with is SMF 30 interval records.

Does anyone have a SAS or something that extracts/analyzes SMF Type 30
records ?

thanks,
Mark.



[login to unmask email]
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
01/21/2008 10:37 AM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
[z/OS v7] Baseline CPU and Storage usage







If anyone was able to create a baseline of CPU usage and Storage usage for
DB2 v7 and IRLM,
could you share some details about your capture methods please.

I can get all sorts off stats about what happened within DB2 and as a % of
what DB2 used, but I want
to measure what % of the whole machine the started tasks are using ?

So far we are not coming up with a satisfactory solution, with any of our
monitoring software products,
and I want a baseline to compare to v8 (unless there is another way to do
this ?)

We have BMC Mainview for z/OS,CICS,DB2, BMC Visualizer, BMC Apptune for
DB2 and of course a
few billion SMF records (still looking at those).

Thanks,
Mark Vickers.


Jorg Lueke <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
01/21/2008 10:10 AM

Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
SMF Accounting Question








Why does Class2 and Class3 Parallel CPU usage gt reported in SMF but not
back to the job that is executing. If I look in the SDSF output I only
see the
Class1 CPU time accounted.

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the 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




This e-mail (and any attachments) may contain information that is
confidential and/or protected by law. Any review, use, distribution or
disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the intended
recipient, please contact the sender by reply email and delete all copies
of this message.


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at www.idug.org 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




This e-mail (and any attachments) may contain information that is
confidential and/or protected by law. Any review, use, distribution or
disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the intended
recipient, please contact the sender by reply email and delete all copies
of this message.



The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the 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