Tablespace DSSIZE Z/OS DB2 V8

Dave Nance

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

Philip Sevetson

Re: Tablespace DSSIZE Z/OS DB2 V8
(in response to Dave Nance)
It is probably significant that DSSIZE is not one of the properties of a
tablespace which you can ALTER. To get a larger DSSIZE you have to
DROP/CREATE the tablespace (and dependent objects, of course).

--Phil Sevetson, NYCAPS DBA Support
Financial Information Services Agency of The City of New York
450 West 33rd Street, 4th Floor
New York, NY 10001
phone: (212) 857-1688
mailto: [login to unmask email]

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



=========
Confidentiality Notice: This e-mail communication, and any attachments, contains confidential and privileged information for the exclusive use of the recipient(s) named above. If you are not an intended recipient, or the employee or agent responsible to deliver it to an intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify me immediately by replying to this message and delete this communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the author and do not necessarily represent the opinions of the agency or the City.
=========



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

Larry Jardine

Re: Tablespace DSSIZE Z/OS DB2 V8
(in response to Philip Sevetson)
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