How does one reset the DB2 bufferpool statistics

Dee Reins

How does one reset the DB2 bufferpool statistics

How does one reset the buffer pools stats.

What I want to do is to reset the bufferpool stats before the online day.
Take the stats after the online day is finished.


Thanks
Dee


______________________________________________________________________

* 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
Attachments

  • import1 (7.9k)

Mark Horrocks

Re: How does one reset the DB2 bufferpool statistics
(in response to Dee Reins)
db2 reset monitor all

----- Original Message -----
From: "Dee Reins" <[login to unmask email]>
Newsgroups: bit.listserv.db2-l
To: <[login to unmask email]>
Sent: Wednesday, November 26, 2008 8:34 PM
Subject: [DB2-L] How does one reset the DB2 bufferpool statistics


>
> How does one reset the buffer pools stats.
>
> What I want to do is to reset the bufferpool stats before the online day.
> Take the stats after the online day is finished.
>
>
> Thanks
> Dee
>
>
> ______________________________________________________________________
>
> * 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

Leon Katsnelson

Re: How does one reset the DB2 bufferpool statistics
(in response to Mark Horrocks)

Sounds like you are on DB2 for z/OS. If you are looking for resetting the
bufferpools on DB2 for LUW, take a look at my blog
http://freedb2.com/2008/11/14/what-is-new-in-db2-express-c-clearing-db2-bufferpools/

Leon Katsnelson
Program Director, IBM Data Servers



FreeDB2






From: Dee Reins <[login to unmask email]>

To: [login to unmask email]

Date: 11/26/2008 03:47 PM

Subject: [DB2-L] How does one reset the DB2 bufferpool statistics







How does one reset the buffer pools stats.

What I want to do is to reset the bufferpool stats before the online day.
Take the stats after the online day is finished.


Thanks
Dee


______________________________________________________________________

* 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

----- Message from Joel Goldstein <[login to unmask email]> on Wed, 26
Nov 2008 19:25:38 +0000 -----

To: [login to unmask email]

Subject: AD: Reducing your DB2 related IT costs in this economy, is
critical for your survival




Subject: Reducing your DB2 related IT costs in this economy, is critical
for your survival


Today, we are faced with a tight economy, and a huge incentive to reduce
both current costs and those projected for the future.
The corporations that survive and prosper in the future are those that
address both current and future costs now.

Viewing our short 3-minute, management oriented, movie at
www.responsivesystems.com/Movie1
will highlight our cost reduction possibilities and achievements. We have
several clients that have
accomplished seven figure cost savings within the first few months of using
our Buffer Pool Tool for DB2.

Where can large cost savings be realized?

a. Reducing CPU overhead by tuning your DB2 buffer pools and IO subsystem
makes more processing capacity available for other tasks. This improves
productivity,
and allows more real work to flow through your system. This helps
avoid or delay a processor upgrade, and the associated huge software
upgrade fees
that pile on top of the processor upgrade cost itself.

b. Finding and correcting poor application access, that causes large
sequential scans of data. These processes burn your CPU, and are one of
the primary causes
of processor upgrades. Buffer Pool Tool will highlight these
problems faster than any other product.
Correcting some of these major performance problems may allow you
to downgrade your processor, and have much lower software renewal/license
costs in the future.

Please consider a trial of Buffer Pool Tool, and let us help you find the
cost saving and reduction opportunities in your systems.

Quite frankly, if we weren't better than our large corporate competition,
we wouldn't still be in the marketplace as the acknowledged Industry
Standard product.

Some of our clients are: three of the top ten banks in the US, seven of
the top 50. Three of the top ten banks in the world, four of the top 20.
Some of the largest
manufacturers, retailers, insurers, and telecommunications companies.
Many dozen of small to
large-range companies.


Thank you for your time.

Joel

Joel Goldstein
President
Responsive Systems
Buffer Pool Tool for DB2, the worldwide industry standard
Performance software that works......
Predicts Group Buffer Pool performance too!
www.responsivesystems.com

Watch the 3-Minute Buffer Pool Tool Movie at:
www.responsivesystems.com/Movie1

tel. (732) 972-1261
fax.(732) 972-9416




IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA


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






IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA


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





______________________________________________________________________

* 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

Dale Hardy

Re: How does one reset the DB2 bufferpool statistics
(in response to Leon Katsnelson)
I believe only an IPL can reset the bufferpool stats.

-DISPLAY BUFFERPOOL (ACTIVE) DETAIL(INTERVAL) LIST(ACTIVE)
Which will display the statistics since the last -DISPLAY.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Dee Reins
Sent: Wednesday, November 26, 2008 3:35 PM
To: [login to unmask email]
Subject: [DB2-L] How does one reset the DB2 bufferpool statistics


How does one reset the buffer pools stats.

What I want to do is to reset the bufferpool stats before the online
day.
Take the stats after the online day is finished.


Thanks
Dee


______________________________________________________________________

* 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
*****************************************************************
IF YOU RECEIVED THIS EMAIL IN ERROR, YOU SHOULD NOTIFY THE SENDER
BY REPLY EMAIL AND THEN DELETE IT (INCLUDING ANY ATTACHMENTS).
*****************************************************************

______________________________________________________________________

* 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

Isaac Yassin

Re: How does one reset the DB2 bufferpool statistics
(in response to Dale Hardy)
Hi,

Be careful with your wishes :-)
You can change it to zero "VPSIZE(0)" and back again
The problem is that it'll affect all those who use it (-904)

Isaac Yassin

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Hardy, Dale
Sent: Monday, December 01, 2008 5:45 PM
To: [login to unmask email]
Subject: Re: [DB2-L] How does one reset the DB2 bufferpool statistics

I believe only an IPL can reset the bufferpool stats.

-DISPLAY BUFFERPOOL (ACTIVE) DETAIL(INTERVAL) LIST(ACTIVE)
Which will display the statistics since the last -DISPLAY.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Dee Reins
Sent: Wednesday, November 26, 2008 3:35 PM
To: [login to unmask email]
Subject: [DB2-L] How does one reset the DB2 bufferpool statistics


How does one reset the buffer pools stats.

What I want to do is to reset the bufferpool stats before the online
day.
Take the stats after the online day is finished.


Thanks
Dee


______________________________________________________________________

* 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
*****************************************************************
IF YOU RECEIVED THIS EMAIL IN ERROR, YOU SHOULD NOTIFY THE SENDER
BY REPLY EMAIL AND THEN DELETE IT (INCLUDING ANY ATTACHMENTS).
*****************************************************************

______________________________________________________________________

* 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

--
I am using the free version of SPAMfighter.
We are a community of 5.7 million users fighting spam.
SPAMfighter has removed 4030 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

The Professional version does not have this message

______________________________________________________________________

* 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