Dynamically add partition

Bob

Dynamically add partition
We have several partitioned tablespaces and our shop standard is to define
them with 35 partitions. Something about having 35 years worth of data.

My question is: Can partitions be added dynamically? It would be so much
easier to define them with say numparts 5 and then add a partition each
year as the new data comes in.

Thanks, Bob

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Chi-Yun (Angela) Fung

Re: Dynamically add partition
(in response to Bob)
Bob,

You can not dynamically add a new partition. In V7 you can only dynamically change the part key range. But then you have to reorg after the alter. In V8 you can roll off the oldest partition and change the part key range to the new range - in your case the new year.

Angela

-----Original Message-----
From: Bob [mailto:[login to unmask email]
Sent: Tuesday, December 30, 2003 2:49 PM
To: [login to unmask email]
Subject: Dynamically add partition


We have several partitioned tablespaces and our shop standard is to define
them with 35 partitions. Something about having 35 years worth of data.

My question is: Can partitions be added dynamically? It would be so much
easier to define them with say numparts 5 and then add a partition each
year as the new data comes in.

Thanks, Bob

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Jim Ruddy

Re: Dynamically add partition
(in response to Chi-Yun (Angela) Fung)
You will have to wait until V8 to be able to add partitions.

Jim Ruddy
DB2 for z/OS Development

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Re: Dynamically add partition
(in response to Jim Ruddy)
That is what I needed to know.
Thanks, Bobby

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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