Extending the boundary of the last partition
You can extend the boundary of the last partition of a table that uses table-controlled partitioning without impacting data availability.
Procedure
![Begin general-use programming interface information.](../cmn/../art/gupi_opn.gif)
Issue the ALTER TABLE statement with the ALTER PARTITION
clause to specify a new boundary for the last partition.
For more details on this process, see Changing the boundary between partitions.
![End general-use programming interface information.](../cmn/../art/gupi_cls.gif)
Example
The following table shows a representation of a table space through the year 2007. You rotated the first partition to be the last partition. Now, you want to extend the last partition so that it includes the year 2008.
Partition | Limit value | Data set name that backs the partition |
---|---|---|
P002 | 12/31/1997 | catname.DSNDBx.dbname.psname.I0001.A002 |
P003 | 12/31/1998 | catname.DSNDBx.dbname.psname.I0001.A003 |
P004 | 12/31/1999 | catname.DSNDBx.dbname.psname.I0001.A004 |
P005 | 12/31/2000 | catname.DSNDBx.dbname.psname.I0001.A005 |
P006 | 12/31/2001 | catname.DSNDBx.dbname.psname.I0001.A006 |
P007 | 12/31/2002 | catname.DSNDBx.dbname.psname.I0001.A007 |
P008 | 12/31/2003 | catname.DSNDBx.dbname.psname.I0001.A008 |
P009 | 12/31/2004 | catname.DSNDBx.dbname.psname.I0001.A009 |
P010 | 12/31/2005 | catname.DSNDBx.dbname.psname.I0001.A010 |
P011 | 12/31/2006 | catname.DSNDBx.dbname.psname.I0001.A011 |
P001 | 12/31/2007 | catname.DSNDBx.dbname.psname.I0001.A001 |
![Begin general-use programming interface information.](../cmn/../art/gupi_opn.gif)
ALTER TABLE TRANS ALTER PARTITION 1 ENDING AT ('12/31/2008');
![End general-use programming interface information.](../cmn/../art/gupi_cls.gif)
You can use the partition immediately after the ALTER statement completes. The partition is not placed in REORG-pending (REORP) status, because it extends the high-range values that were not previously used.