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
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.
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 |
ALTER TABLE TRANS ALTER PARTITION 1 ENDING AT ('12/31/2008');
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.