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. To extend the boundary of the last partition:

Issue the ALTER TABLE statement with the ALTER PARTITION clause to specify a new boundary for the last partition. End general-use programming interface information.
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.

Table 1. Table space through the year 2007
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.To extend the boundary of the last partition to include the year 2008, issue the following statement: 

ALTER TABLE TRANS ALTER PARTITION 1 ENDING AT ('12/31/2008');
End general-use programming interface information.

You can use the partition immediately after the ALTER statement completes. The partition is not placed in any restrictive status, because it extends the high-range values that were not previously used.