User guide

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-004 16-11
• To allocate extents, click on Allocate then enter the number of
extents in the Allocate field
• To deallocate unused extents, click on Allocate to remove the
checkmark.
3. 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.
4. Enter the maximum number of extents in the Max Extents field.
5. Enable or disable the Reset-Broken flag by clicking on Reset Broken.
Display Dependencies
Before altering partitions to an index, you can analyze the impact of the
proposed changes:
• To display the programs which depend on the index, click on
Dependent Programs. Programs which would be invalidated by
adding partitions are displayed.
• To display all objects, including programs, which depend on the
partitions, click on Dependent Objects. All SQL objects which
depend on the index partitions are displayed.
Alter the Partitions
To alter the partitions for the index, 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.
Drop Partitions
To drop partitions from an index, click on Index Partitions in the Main
window, then click on Drop. The Drop Partitions window will appear.