Change a partition
- In the System i Navigator window, expand the system you want to use.
- Expand Databases and the database that you want to work with.
- Expand Schemas and the schema you want to work with.
- Select Tables. The existing tables appear in the right pane.
- Right-click the table name and select Definition.
- On the Table definition dialog, select the Partitioning tab.
- Select the partition you want to change from the Partitions area, and click Definition.... The New Table Defintion dialog opens.
- You can change the partition name, partition number, or range values. If you want the partition to include the
specified start or end value, select the Include range key start values or Include range key
end values option. To exclude the end value from the partition, deselect this option.
Note: If you change the range values, make sure that the new values you specify are not included in
another partition.
- Click OK to save your changes.
- Click OK to close the Table Definition dialog.
To change the method of partitioning (for example from hash to range partitioning) first delete the existing partitions,
then create new partitions. See Create a partition and
Delete a partition.