Owner manual

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-005 14-5
To assign miscellaneous attributes
1. Enter the key tag in the Key Tag field..
2. Enable or disable the invalidate-programs option by clicking on
Invalidate.
3. Enable or disable parallel execution by clicking on Parallel Execution. If
enabled, enter the configuration file name in the Configuration field.
4. Enable or disable shared access by clicking on Shared Access.
Save the Index
To save 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.
Altering an Index
Using the Alter Index window, you can change an index’s security or file
attributes, or add, change, or delete partitions in the index. You can also
analyze the impact of the changes on other SQL objects before you save
the changes.
To display the Alter Index window, click on Indexes in the main window,
then click on Alter. The Alter Index window is displayed, as shown in
Figure 14-2.