HP NonStop G-Series User Manual

Page 243

Advertising
background image

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-004

16-17

Assign File Format

Select the Format Specification for the partition by clicking either
Format1 or Format2 option button.

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
index partitions, click on Dependent Objects. All SQL objects
which depend on the index partitions are displayed.

Advertising