Owner manual

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-005 16-15
• 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
D
slack 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 simple 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
whichdependontheindexpartitionsaredisplayed.
Move the Partition
To perform the simple move, click on one of the following:
• Execute. Executes the command immediately.
• Show. Displays the SQL commands created by dba/m Database
Manager without executing them.
• Queue. Queues the command to be submitted in a batch later.
Performing a One-Way Split
To perform a one-way split of a index partition, click on Index Partitions in
the Main window, then click on One-Way Split. The One-Way Split
window will be displayed, as shown in Figure 16-9.