Owner manual

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-005 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.