User guide

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-004 15-5
the sampling rate and dba/m Database Manager will compute the primary
key values when you press the Recompute button.
Figure 15-3. Graphical Window.
Automatic Design
To have dba/m Database Manager automatically design table partitions
1. Specify the number of partitions in the Number of Partitions pane in the
Auto Design pane as shown in Figure 15-1.
2. Specify the sample rate.
3. If you want Partonly then Click Partonly option.
4. Click on Auto Design. The time required to complete partition design
depends on the size of the table and the sample rate. A message box
with this message is displayed.
5. To see the new table partitions, click on Get Results. The primary keys
for balanced partitions are shown in the Design Partition window as
showninFigure15-4.ClickontheGraphbuttonintheDesign
Partition window to view the results in graphical form.