[DB2-L] Tablespace DSSIZE Z/OS DB2 V8

Walter Janißen

[DB2-L] Tablespace DSSIZE Z/OS DB2 V8
Dave

64 partitions is the maximun number of partitions for the old ones. So if you omit DSSIZE, the maximum growth is 64 GB. That means, each partition is limited to 1 GB. How do you think 2GB?


Bitte richten Sie, falls Sie es nicht schon tun, in Zukunft alle E-Mails nicht mehr an Einzelpersonen, sondern
immer an das Postfach "LI25103D - Entwicklungssupport - Gruppenpostfach".
Ansonsten kann sich die Bearbeitung Ihrer E-Mail bedingt durch Urlaub, Gleittag, Krankheit, Projektarbeit in Köln,
ZEITplus o.ä. verzögern.
Vielen Dank!

Mit freundlichen Grüßen
Walter Janißen

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Laufzeitarchitektur
Hans-Böckler-Str. 36
D-40477 Düsseldorf
Tel.: +49 211 477-2928
Fax: +49 211 477-2615
mailto:[login to unmask email]
http:// www.itergo.com
Vorsitzender des Aufsichtsrats: Dr. Torsten Oletzky
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Dr. Michael Regauer, Wolfgang Schön.
Sitz: Düsseldorf | Handelsregister: Amtsgericht Düsseldorf, HRB 37996


-----Ursprüngliche Nachricht-----
Von: DB2 Data Base Discussion List [mailto:[login to unmask email] Im Auftrag von Dave Nance
Gesendet: Freitag, 30. November 2007 16:35
An: [login to unmask email]
Betreff: [DB2-L] Tablespace DSSIZE Z/OS DB2 V8

Thanks for any help anyone can give me.

We had some tablespaces that were defined with 50 partitions. Which the book states 50 partitions and not defined as large, then you are limited to 2G.
So, we decided rather than dropping and recreating, we would use some of the new V8 features. We added 15 partitions and then used reorg rebalance and reorged again. Worked great!!! Plenty of room for growth or so we thought. Now when using the admin tool and looking at DDL for the tablespace we see that it still has 2G as the DSSIZE. Shouldn't that have been upped to 4G when we added the 14th new partition(put us up to 64 parts)? Any help would be appreciated.

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

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

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

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

Steen Rasmussen

Re: AW: [DB2-L] Tablespace DSSIZE Z/OS DB2 V8
(in response to Walter Janißen)
As already mentioned, you will need to drop and create the tablespace in
order to take advantage of DSSIZE and the bigger VSAM datasets. In your
case having 50 parts you are limited to 1GB according to the snip from
the IBM doc below sice the Tablespace is created WITHOUT DSSIZE.

If you specify DSSIZE, you must also specify NUMPARTS or LOB.
The following values are valid:

1 G 1 gigabyte
2 G 2 gigabytes
4 G 4 gigabytes
8 G 8 gigabytes
16 G 16 gigabytes
32 G 32 gigabytes
64 G 64 gigabytes

To specify a value greater than 4 G, the following conditions must be
true:
DB2 is running with DFSMS Version 1 Release 5.
The data sets for the table space are associated with a DFSMS data class
that has been specified with extended format and extended
addressability. For all table spaces except LOB table spaces, if DSSIZE
(or LARGE) is omitted, the default for the maximum size of each
partition depends on the value of NUMPARTS:
If NUMPARTS is ... Maximum partition size is...
1 to 16 4 GB
17 to 32 2 GB
33 to 64 1 GB
65 to 254 4 GB


Steen Rasmussen
CA
Principal Technical Specialist DB2 tools
IBM Certified Database Associate -- DB2 9 Fundamentals
IBM Certified Database Administrator - DB2 9 DBA for z/OS

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

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

David Simpson

Re: Tablespace DSSIZE Z/OS DB2 V8
(in response to Steen Rasmussen)
When you altered the table and added partitions you were converted to table controlled partitioning which does give you more flexibility. The DSSIZE, however, cannot be changed. When you go to DSSIZE 4G (or above) you get a bigger RID and this requires a drop/recreate.


David Simpson
Senior Technical Advisor
Themis Training
[login to unmask email]
http://www.themisinc.com

________________________________

From: DB2 Data Base Discussion List on behalf of Dave Nance
Sent: Fri 11/30/2007 9:34 AM
To: [login to unmask email]
Subject: [DB2-L] Tablespace DSSIZE Z/OS DB2 V8



Thanks for any help anyone can give me.

We had some tablespaces that were defined with 50 partitions. Which the
book states 50 partitions and not defined as large, then you are limited to 2G.
So, we decided rather than dropping and recreating, we would use some of
the new V8 features. We added 15 partitions and then used reorg rebalance
and reorged again. Worked great!!! Plenty of room for growth or so we
thought. Now when using the admin tool and looking at DDL for the tablespace
we see that it still has 2G as the DSSIZE. Shouldn't that have been upped to
4G when we added the 14th new partition(put us up to 64 parts)? Any help
would be appreciated.

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org < http://www.idug.org/ >

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



IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

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

Max Scarpa

Re: Tablespace DSSIZE Z/OS DB2 V8
(in response to David Simpson)
DSSIZE is not 'DB2-related' only but it's something that uses z/OS
services and SMS and it's structural to DB2 LDS. So you cannot change it
adding partitions. You'll be limited to the valued you specified in the
past.

Be aware taht your upper limits are approaching in any case, if you do not
ALTER that tablespace (hopefully in a long time).

Max Scarpa
Certified reindeers driver (red dressed only)






"Jardine, Lawrence J" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
30/11/2007 16.46
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
Re: [DB2-L] Tablespace DSSIZE Z/OS DB2 V8






First, if you do not specify LARGE or DSSIZE, then the limit for a
tablespace with 50 partitions is 1G. I suspect you have explicitly
defined the tablespace partitions as 2G.

You cannot change DSSIZE by adding partitions; in fact you cannot change
DSSIZE except by dropping and recreating the tablespace.


Larry Jardine
Production DBA
TDM Website: http://opsvcs.aetna.com/oltpdb/

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Dave Nance
Sent: Friday, November 30, 2007 10:35 AM
To: [login to unmask email]
Subject: [DB2-L] Tablespace DSSIZE Z/OS DB2 V8

Thanks for any help anyone can give me.

We had some tablespaces that were defined with 50 partitions. Which
the book states 50 partitions and not defined as large, then you are
limited to 2G.
So, we decided rather than dropping and recreating, we would use some of
the new V8 features. We added 15 partitions and then used reorg
rebalance and reorged again. Worked great!!! Plenty of room for growth
or so we thought. Now when using the admin tool and looking at DDL for
the tablespace we see that it still has 2G as the DSSIZE. Shouldn't that
have been upped to 4G when we added the 14th new partition(put us up to
64 parts)? Any help would be appreciated.

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion
listserv that are being implemented to improve reliability and the
overall user experience of DB2-L. These changes are coming on November
30th. Details at http://www.idug.org

------------------------------------------------------------------------
---------
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 e-mail may contain confidential or privileged information. If
you think you have received this e-mail in error, please advise the
sender by reply e-mail and then delete this e-mail immediately.
Thank you. Aetna

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion
listserv that are being implemented to improve reliability and the overall
user experience of DB2-L. These changes are coming on November 30th.
Details at http://www.idug.org

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


IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

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