User guide

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-004 15-21
Assign Primary-Key Values
Use the Primary-Key pane to specify primary-key values for both
partitions.
To assign primary-key values
1. In the Column Name field, choose a column of the primary key by
clicking on the name from the list of column names.
2. Place the cursor in the First Key field for the selected column and enter
the value for that column.
3. Repeat Steps 1 and 2 for all other columns of the primary-key.
Display Dependencies
Before performing a two-way 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
table partitions, click on Dependent Objects. All SQL objects
which depend on the table partitions are displayed.
Move the Partition
To perform the two-way 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.