Increasing DSSIZE Vs. Increasing No. Partitions

Mark Grundigz

Increasing DSSIZE Vs. Increasing No. Partitions
Hello Listers,

Our shop is running DB2 V7 on z/OS Ver 1.4 and we have a few partitioned
tablespaces which are currently defined as "LARGE". The partitions are
almost at the 4G limit and we have a choice of either increasing the number
of partitions or increasing the DSSIZE (to more than 4G) while keeping the
same number of partitions we have now.

Can you please share your experiences with increasing the DSSIZE Vs.
increasing the number of partitions ?

As always, thanks a lot for your time and responses.

Mark Grundigz

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

Bob Galeotti

Re: Increasing DSSIZE Vs. Increasing No. Partitions
(in response to Mark Grundigz)
Will the application drive whether you go with increased DSSIZE versus
increased partitions? Example - tablespace is partitioned for number of
years, or months, or regions, or states, etc. Is that the case? If so, you
just answered your question - DSSIZE. If not, you still have a good
question.
Bob Galeotti

----- Original Message -----
From: "Mark Grundigz" <[login to unmask email]>
Newsgroups: bit.listserv.db2-l
To: <[login to unmask email]>
Sent: Thursday, December 16, 2004 4:00 PM
Subject: Increasing DSSIZE Vs. Increasing No. Partitions


> Hello Listers,
>
> Our shop is running DB2 V7 on z/OS Ver 1.4 and we have a few partitioned
> tablespaces which are currently defined as "LARGE". The partitions are
> almost at the 4G limit and we have a choice of either increasing the
number
> of partitions or increasing the DSSIZE (to more than 4G) while keeping the
> same number of partitions we have now.
>
> Can you please share your experiences with increasing the DSSIZE Vs.
> increasing the number of partitions ?
>
> As always, thanks a lot for your time and responses.
>
> Mark Grundigz
>
> --------------------------------------------------------------------------
-------
> 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

Mark Grundigz

Re: Increasing DSSIZE Vs. Increasing No. Partitions
(in response to Bob Galeotti)
Bob,

Thanks for your response.

Currently we have multiple values assigned to a single partition and so we
have an option of increasing the number of partitions by assigning each
value to an individual partition.

Thanks,
Mark Grundigz

On Thu, 16 Dec 2004 16:17:07 -0500, Bob Galeotti <[login to unmask email]>
wrote:

>Will the application drive whether you go with increased DSSIZE versus
>increased partitions? Example - tablespace is partitioned for number of
>years, or months, or regions, or states, etc. Is that the case? If so,
you
>just answered your question - DSSIZE. If not, you still have a good
>question.
>Bob Galeotti
>
>----- Original Message -----
>From: "Mark Grundigz" <[login to unmask email]>
>Newsgroups: bit.listserv.db2-l
>To: <[login to unmask email]>
>Sent: Thursday, December 16, 2004 4:00 PM
>Subject: Increasing DSSIZE Vs. Increasing No. Partitions
>
>
>> Hello Listers,
>>
>> Our shop is running DB2 V7 on z/OS Ver 1.4 and we have a few partitioned
>> tablespaces which are currently defined as "LARGE". The partitions are
>> almost at the 4G limit and we have a choice of either increasing the
>number
>> of partitions or increasing the DSSIZE (to more than 4G) while keeping
the
>> same number of partitions we have now.
>>
>> Can you please share your experiences with increasing the DSSIZE Vs.
>> increasing the number of partitions ?
>>
>> As always, thanks a lot for your time and responses.
>>
>> Mark Grundigz
>>
>> -------------------------------------------------------------------------
-
>-------
>> 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 DB2-L-
[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

Walter Jani&#223;en

Re: Increasing DSSIZE Vs. Increasing No. Partitions
(in response to Mark Grundigz)
Mark

Just some other thoughts

If you go with DSSIZE greater than 4G, you have to have the right SMS
version, because the datasets must be EA-enabled (I don't know which
version)

I would increase the number of partitions, because the bigger the datasets
the more difficult it is to run utilities against them. Are you running
share level change copies and reorgs? Do you have any service level
agreements with your customers, how long a partition is allowed to be
offline e.g. in case of recovery?

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

Chris Andrews

Re: Increasing DSSIZE Vs. Increasing No. Partitions
(in response to Walter Janißen)
Another issues is disk sizes. A lot of tools will try and put all the size
for a partition in primary quantity and asking SMS for something bigger
than a disk usually doesn't work, so it can be easier to split into more
partitions and for all the other reasons quoted.

You can also increase parallelism by doing so.

In terms of work at V7 for either change, assuming you will balance the
rows across the tablespaces is roughly the same.

I'd be tempted to do both lower the primary size back to 1GB and multiply
by 4 the partitions to give myself a lot of room for growth and avoid doing
this again. At the same time set DSSIZE to 64GB so you can then when/if
necessary take the DSSIZE option which may be easier/better in n years time.

Chris Andrews
[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

Phil Grainger

Re: Increasing DSSIZE Vs. Increasing No. Partitions
(in response to Chris Andrews)
If you increase the DSSIZE, bear in mind that in V8 that may limit the
maximum number of partitions you can have....

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


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Mark Grundigz
Sent: 16 December 2004 21:18
To: [login to unmask email]
Subject: Re: Increasing DSSIZE Vs. Increasing No. Partitions

Bob,

Thanks for your response.

Currently we have multiple values assigned to a single partition and so
we have an option of increasing the number of partitions by assigning
each value to an individual partition.

Thanks,
Mark Grundigz

On Thu, 16 Dec 2004 16:17:07 -0500, Bob Galeotti
<[login to unmask email]>
wrote:

>Will the application drive whether you go with increased DSSIZE versus
>increased partitions? Example - tablespace is partitioned for number
>of years, or months, or regions, or states, etc. Is that the case? If

>so,
you
>just answered your question - DSSIZE. If not, you still have a good
>question.
>Bob Galeotti
>
>----- Original Message -----
>From: "Mark Grundigz" <[login to unmask email]>
>Newsgroups: bit.listserv.db2-l
>To: <[login to unmask email]>
>Sent: Thursday, December 16, 2004 4:00 PM
>Subject: Increasing DSSIZE Vs. Increasing No. Partitions
>
>
>> Hello Listers,
>>
>> Our shop is running DB2 V7 on z/OS Ver 1.4 and we have a few
>> partitioned tablespaces which are currently defined as "LARGE". The
>> partitions are almost at the 4G limit and we have a choice of either
>> increasing the
>number
>> of partitions or increasing the DSSIZE (to more than 4G) while
>> keeping
the
>> same number of partitions we have now.
>>
>> Can you please share your experiences with increasing the DSSIZE Vs.
>> increasing the number of partitions ?
>>
>> As always, thanks a lot for your time and responses.
>>
>> Mark Grundigz
>>
>> ---------------------------------------------------------------------
>> ----
-
>-------
>> 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 DB2-L-
[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