User guide

Managing Table Partitions15-20
Choose Table
1. In the list of catalogs shown in the Base Table Catalog and Base Tables
panes, double-click on the catalog that contains the base table for the
partition. The tables in the catalog are displayed in the Base Table field.
2. Double-click on the table you want to use as a base table.
3. Click on Two Way/Split.
Assign Names and Locations
Use the First Target Specification pane to assign a name and location for
the first partition you are moving. Then complete the Second Target
Specification pane for the second partition.
1. Enter the name of the target partition in the Partition field, or use the
Volume button to select the volume from the Volumes window.
2. Click on the arrow in the Catalog field to display a list of catalogs.
3. Double-click on the name of the catalog.
Assign File Attributes
Specify the file attributes of the first partition, then the second partition.
To assign the file attributes
1. In the Extent in Pages pane, perform one of the following:
• To enter the primary and secondary extent sizes, click on
Primary, then enter the primary extent size in the Primary field
and the secondary extent size in the Secondary field.
• To enter the number of extents, click on Extents, then enter the
number of extents in the Extents field.
2. Enter the maximum number of extents in the Max Extents field.
3. Enter the minimum percentage of space to be left in a data block in the
Dslack field.
4. Enter the minimum percentage of space to be left in an index block in
the I
slack field.
5. Enter the minimum percentage of space to be left in data and index
blocks in the Slack field.