User guide

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-004 15-11
Altering Partitions
Use the Alter partition pane to modify the file attributes of a partition. To
alter a partition, click on Table Partitions in the Main window, then click
on Alter. The Alter Partitions window will be displayed, as shown in Figure
15-7.
Figure 15-7. Alter Partitions Window.
To alter a partition
1. Click on the name of the partition you want to alter in the partition
name and catalog pane.
2. To change extent allocations, perform one of the following:
• To allocate extents, click on Allocate then enter the number of
extents in the Allocate field
• To deallocate unused extents, click on Allocate to remove the
checkmark.
3. 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.