HP NonStop G-Series - Manual (Page 224)

Managing Table Partitions 15-18
1. Enter the name of the target partition in the partition field or click on
the Volume button to select the volume from the Volume window.
2. Click on the arrows in the Catalog field to display a list of catalogs.
3. Double-click on the name of the catalog.
Assign File Attributes
Use the First Target Specification pane to specify the partition’s file
attributes.
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 Islack field.
5.
Enter the minimum percentage of space to be left in data and index
blocks in the Slack field.
Display Dependencies
Before performing a one-way move, you can analyze the impact of the
changes:
•
To display the programs which depend on the partitions, click
on Dependent Programs. Programs which would be invalidated
by moving the partitions are displayed.
•
To display all objects, including programs, which depend on the
table partitions, click on Dependent Objects. All SQL objects
which depend on the table partitions are displayed.