Converting Bufferpools to dataspaces

Michael Toole

Converting Bufferpools to dataspaces
I'm about to convert some of my bufferpools to dataspaces and add a couple
of gigabytes to them.

I was wondering if anyone could share their experiances with bufferpools in
dataspaces with me.

Thanks.

Mike.

Mike Toole
Product Consultant
The Auto Club Group
313-336-1783
[login to unmask email]

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

Cathy Taddei

Re: Converting Bufferpools to dataspaces
(in response to Michael Toole)
Hi Mike. We recently upgraded to a z/Architecture machine that does not
support expanded storage. At that time, I converted all my bufferpools
with hiperpools to dataspaces, and simply added the virtual pool and
hiperpool sizes to get the dataspace size. This did not work as well as
expected, because the LPAR was running with less storage than it had
before: i.e., before the upgrade it had 2gb central and 2gb expanded,
after the upgrade it had 3.5gb central. We were paging a little, so I
reduced the size of some bufferpools, which relieved the contention for
central storage, and we are now living happily ever after.

The moral of this story is twofold:
1) It made no difference whether the bufferpool type was primary or
dataspace; I could not detect any difference in performance. Dataspaces
are good for DBM1 virtual storage constraint relief.
2) Whatever changes you make in total bufferpool size, you have to have
enough central storage to back them! Don't just add a few gigabytes
unless you are getting more storage on your machine, or you are certain
that the storage you have is underutilized.

HTH,
Cathy Taddei

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Toole, Michael
Sent: Monday, January 03, 2005 8:30 AM
To: [login to unmask email]
Subject: [DB2-L] Converting Bufferpools to dataspaces

I'm about to convert some of my bufferpools to dataspaces and add a
couple
of gigabytes to them.

I was wondering if anyone could share their experiances with bufferpools
in
dataspaces with me.

Thanks.

Mike.

Mike Toole
Product Consultant
The Auto Club Group
313-336-1783
[login to unmask email]

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


------------------------------------------------------------------------------

This email is confidential and may be legally privileged.

It is intended solely for the addressee. Access to this email by anyone else, unless expressly approved by the sender or an authorized addressee, is unauthorized.

If you are not the intended recipient, any disclosure, copying, distribution or any action omitted or taken in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email in error, please contact the sender, delete this e-mail and destroy all copies.

======

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

Jeff Frazier

Re: Converting Bufferpools to dataspaces
(in response to Cathy Taddei)
Mike, we also converted to dataspaces a few months ago. one other thing to
watch out for is your thresholds, as making your dataspace bufferpools
larger will affect those also.
Jeff




"Taddei, Cathy" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
01/03/2005 01:28 PM
Please respond to DB2 Database Discussion list at IDUG


To: [login to unmask email]
cc:
Subject: Re: [DB2-L] Converting Bufferpools to dataspaces


Hi Mike. We recently upgraded to a z/Architecture machine that does not
support expanded storage. At that time, I converted all my bufferpools
with hiperpools to dataspaces, and simply added the virtual pool and
hiperpool sizes to get the dataspace size. This did not work as well as
expected, because the LPAR was running with less storage than it had
before: i.e., before the upgrade it had 2gb central and 2gb expanded,
after the upgrade it had 3.5gb central. We were paging a little, so I
reduced the size of some bufferpools, which relieved the contention for
central storage, and we are now living happily ever after.

The moral of this story is twofold:
1) It made no difference whether the bufferpool type was primary or
dataspace; I could not detect any difference in performance. Dataspaces
are good for DBM1 virtual storage constraint relief.
2) Whatever changes you make in total bufferpool size, you have to have
enough central storage to back them! Don't just add a few gigabytes
unless you are getting more storage on your machine, or you are certain
that the storage you have is underutilized.

HTH,
Cathy Taddei

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Toole, Michael
Sent: Monday, January 03, 2005 8:30 AM
To: [login to unmask email]
Subject: [DB2-L] Converting Bufferpools to dataspaces

I'm about to convert some of my bufferpools to dataspaces and add a
couple
of gigabytes to them.

I was wondering if anyone could share their experiances with bufferpools
in
dataspaces with me.

Thanks.

Mike.

Mike Toole
Product Consultant
The Auto Club Group
313-336-1783
[login to unmask email]

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


------------------------------------------------------------------------------

This email is confidential and may be legally privileged.

It is intended solely for the addressee. Access to this email by anyone
else, unless expressly approved by the sender or an authorized addressee,
is unauthorized.

If you are not the intended recipient, any disclosure, copying,
distribution or any action omitted or taken in reliance on it, is
prohibited and may be unlawful. If you believe that you have received this
email in error, please contact the sender, delete this e-mail and destroy
all copies.

=====

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

Michael Toole

Re: Converting Bufferpools to dataspaces
(in response to Jeff Frazier)
Thanks Cathy

Mike Toole
Product Consultant
The Auto Club Group
313-336-1783
[login to unmask email]




-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Taddei, Cathy
Sent: Monday, January 03, 2005 1:29 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Converting Bufferpools to dataspaces


Hi Mike. We recently upgraded to a z/Architecture machine that does not
support expanded storage. At that time, I converted all my bufferpools
with hiperpools to dataspaces, and simply added the virtual pool and
hiperpool sizes to get the dataspace size. This did not work as well as
expected, because the LPAR was running with less storage than it had
before: i.e., before the upgrade it had 2gb central and 2gb expanded,
after the upgrade it had 3.5gb central. We were paging a little, so I
reduced the size of some bufferpools, which relieved the contention for
central storage, and we are now living happily ever after.

The moral of this story is twofold:
1) It made no difference whether the bufferpool type was primary or
dataspace; I could not detect any difference in performance. Dataspaces
are good for DBM1 virtual storage constraint relief.
2) Whatever changes you make in total bufferpool size, you have to have
enough central storage to back them! Don't just add a few gigabytes
unless you are getting more storage on your machine, or you are certain
that the storage you have is underutilized.

HTH,
Cathy Taddei

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Toole, Michael
Sent: Monday, January 03, 2005 8:30 AM
To: [login to unmask email]
Subject: [DB2-L] Converting Bufferpools to dataspaces

I'm about to convert some of my bufferpools to dataspaces and add a
couple
of gigabytes to them.

I was wondering if anyone could share their experiances with bufferpools
in
dataspaces with me.

Thanks.

Mike.

Mike Toole
Product Consultant
The Auto Club Group
313-336-1783
[login to unmask email]

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


----------------------------------------------------------------------------
--

This email is confidential and may be legally privileged.

It is intended solely for the addressee. Access to this email by anyone
else, unless expressly approved by the sender or an authorized addressee, is
unauthorized.

If you are not the intended recipient, any disclosure, copying, distribution
or any action omitted or taken in reliance on it, is prohibited and may be
unlawful. If you believe that you have received this email in error, please
contact the sender, delete this e-mail and destroy all copies.

===
==

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

Michael Toole

Re: Converting Bufferpools to dataspaces
(in response to Michael Toole)
Thanks Jeff


Mike Toole
Product Consultant
The Auto Club Group
313-336-1783
[login to unmask email]


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
Jeff Frazier
Sent: Monday, January 03, 2005 1:35 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Converting Bufferpools to dataspaces



Mike, we also converted to dataspaces a few months ago. one other thing to
watch out for is your thresholds, as making your dataspace bufferpools
larger will affect those also.
Jeff



"Taddei, Cathy" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>


01/03/2005 01:28 PM
Please respond to DB2 Database Discussion list at IDUG



To: [login to unmask email]
cc:
Subject: Re: [DB2-L] Converting Bufferpools to dataspaces



Hi Mike. We recently upgraded to a z/Architecture machine that does not
support expanded storage. At that time, I converted all my bufferpools
with hiperpools to dataspaces, and simply added the virtual pool and
hiperpool sizes to get the dataspace size. This did not work as well as
expected, because the LPAR was running with less storage than it had
before: i.e., before the upgrade it had 2gb central and 2gb expanded,
after the upgrade it had 3.5gb central. We were paging a little, so I
reduced the size of some bufferpools, which relieved the contention for
central storage, and we are now living happily ever after.

The moral of this story is twofold:
1) It made no difference whether the bufferpool type was primary or
dataspace; I could not detect any difference in performance. Dataspaces
are good for DBM1 virtual storage constraint relief.
2) Whatever changes you make in total bufferpool size, you have to have
enough central storage to back them! Don't just add a few gigabytes
unless you are getting more storage on your machine, or you are certain
that the storage you have is underutilized.

HTH,
Cathy Taddei

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Toole, Michael
Sent: Monday, January 03, 2005 8:30 AM
To: [login to unmask email]
Subject: [DB2-L] Converting Bufferpools to dataspaces

I'm about to convert some of my bufferpools to dataspaces and add a
couple
of gigabytes to them.

I was wondering if anyone could share their experiances with bufferpools
in
dataspaces with me.

Thanks.

Mike.

Mike Toole
Product Consultant
The Auto Club Group
313-336-1783
[login to unmask email]

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


----------------------------------------------------------------------------
--

This email is confidential and may be legally privileged.

It is intended solely for the addressee. Access to this email by anyone
else, unless expressly approved by the sender or an authorized addressee, is
unauthorized.

If you are not the intended recipient, any disclosure, copying, distribution
or any action omitted or taken in reliance on it, is prohibited and may be
unlawful. If you believe that you have received this email in error, please
contact the sender, delete this e-mail and destroy all copies.

===
==

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


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

Fred Nijdam

Re: Converting Bufferpools to dataspaces
(in response to Michael Toole)
Hey,

All valid reply's on your question.
- Sure you 've to check REAL storage
- Sure you've to check your thresholds, specially these with dynamic
prefetch. On our site I had to adjust these (just a little but ..) to run
the batch as usual (and not 10 times slower).
- After all tuning becomes easier with just one kind of buffer pool.

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