HP NonStop G-Series User Manual

Page 246

Advertising
background image

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

16-19

Choose Index

1. In the list of catalogs shown in the Index Catalog and Indexes panes,

double-click on the catalog that contains the index for the partition.
The indexes in the catalog are displayed in the Index field.

2. Double-click on the index you want to use.

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 Islack field.

5. Enter the minimum percentage of space to be left in data and index

blocks in the Slack field.

Advertising