beautypg.com

Adding partitions – HP Integrity NonStop H-Series User Manual

Page 225

background image

dba/m Database Manager V7.1 User's Guide – 540156-001

15-7

Choose Base Table

Use the Base Table Catalog and Base Table panes to choose base tables.

1.

In the list of catalogs shown in the Base Table Catalog field, 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.

Assign Sample Rate

Enter the sample rate in the Sample Rate field.

Compute Row Distribution

Click on Compute. The elapsed time to compute the number of rows may
take a long time depending on the sample rate and size of the table. Click
on View to view the results. The results are shown in the Monitor
Partition window.

Adding Partitions

To add partitions to a table, click on Table Partitions in the Main window,
then click on Add. The Add Partition window will be displayed, as shown
in Figure 15-5.

This manual is related to the following products: